Blog Archives

Windows 10 Date and Time Formats

By default, most UK PCs are setup to use the 24 hour clock, so 1.13pm shows as 13.13 and the date in the common format of 24.04.16 like this:-


To adjust it, right click with your mouse on the date/time to reveal this menu:-

After choosing “Adjust date/time”, you will see this screen:-

After selecting “Change date and time formats”, you’ll see a screen to adjust the Date and Time formats as shown below:-

As you can see, the default menus use coding which is hard to understand, so I’ve shown examples beside each to help you.

Once you’ve selected your settings, click on the left arrow to return to the previous screen to see the result. Then you can close the window completely.

Advertisements

Excel – How to combine 2 cells into one

Do you have a column containing parts of a full name….that you’d prefer to have in a single cell?

It’s very simple to combine them with a simple Excel formulae.

Joining 2 cells

NOTE: It’s essential to include the double quote marks – and a space – to ensure the correct result.

If you need to do the reverse – split a cell into 2 or 3 (eg. for the first, middle and last name), see this article

 ~~~If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 

Windows 8 Keyboard Shortcut

Here’s an excellent shortcut, especially if you’re using Windows 8 – To view the Desktop, simply press the Windows logo key with the letter D

index(3)

Excel – How to split a column in 2 or 3

Do you have a column containing a full name, like this:-

Before

….that you’d prefer to have separated into first and last name ?

It’s very simple to separate them using a few steps in Excel. Here’s how:- Read the rest of this entry