How to change date and time format
Now we will see that how we can change date and time format in MS Excel.
We can see that on screen we have different type of dates written, like birth date, date of hiring, sales date etc...
As we know that if we want to write date in MS Excel we use '/' or '-' symbol. By default format of date in MS Excel is MM/DD/YYYY.
Suppose if we want the format of the date to be changed according to our need, so for that we will press 'Ctrl+1' and a dialog box of 'Format cell' will get opened, than we can select our desirable date format.
Now if we want our date to be in long format, then we don't need to go to format cell dialogue box, we can change it in HOME tab where we can see a column 'Date'. When we open it we can see that there are number of different formats available there.
Now if we choose long date option then our date will be in the format of 'Day, Month, Date, Year'.
Now suppose if you want the format of date according to our requirement, then we can set the format of date by going in to format cell dialogue box, and writing the format of date which we want in the format column.
If we want to get the date in standard form again, than we will go to the date column and select standard date format.
If we want to view that which particular month it is written in any date by name, then we can select the date and press 'Ctrl+Shift+3' keys.
Now we will talk about time format, suppose we want to change the time which we have written in 24 hour format to 12 hour format, then we can use a shortcut for that, i.e. by pressing 'Ctrl+Shift+2', which will change all the time format into AM and PM.
Share a personalized message with your friends.