Course Content

Course Content

Description

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.

FAQs

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere