How do you format date and time in Excel?

Select the cells you want to format. Press CTRL+1. In the Format Cells box, click the Number tab. In the Category list, click Date. Under Type, pick a date format. If you want to use a date format according to how another language displays dates, choose the language in Locale (location).

Is there a list of shortcuts for formatting date-time in MS Excel?

The following is a list of shortcuts for formatting date-time in MS Excel: Ctrl + Shift + R - Format cells as date. Ctrl + Shift + D - Format cells as time. Ctrl + Shift + T - Format cells as time with am/pm. Ctrl + Shift + H - Format cells as 24 hour clock. Ctrl+Shift+ A – Apply the same formatting to all cells in the selection.

What are the different ways to format date-time in MS Excel?

There are three ways to format date-time in MS Excel. They are: Enter the date-time using the date and time formats (for example, 1/1/2016 12:00 AM) Use the format function (for example, ="January 1st 2016 at 12:00 AM") Click on "Format Cells" in the "Home" tab and select "Custom." Then enter a custom date-time format in the box that pops up.

MS Excel Course > Formating

Formatting Date-Time in MS Excel

314.4k

Start a new search

To find content from modules and lessons

Overview

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.

Select the cells you want to format.
Press CTRL+1.
In the Format Cells box, click the Number tab.
In the Category list, click Date.
Under Type, pick a date format.
If you want to use a date format according to how another language displays dates, choose
the language in Locale (location).

To apply the Format function, we need to select the cell that contains the date-time value and then type a comma after it. After that, we should type "Format" and then press Enter on our keyboard. The screen will show us two options - General and Custom.

The following is a list of shortcuts for formatting date-time in MS Excel:

Ctrl + Shift + R - Format cells as date.
Ctrl + Shift + D - Format cells as time.
Ctrl + Shift + T - Format cells as time with am/pm.
Ctrl + Shift + H - Format cells as 24 hour clock.
Ctrl+Shift+ A – Apply the same formatting to all cells in the selection.

You can use the Preview tab to see how your changes will look before you apply them to your document. You’ll also be able to see how the formatting will change for each paragraph, including lists and headings. Previewing formatting changes before applying them is a great way to make sure that you are not wasting time on formatting that will not be used.

There are three ways to format date-time in MS Excel. They are:

Enter the date-time using the date and time formats (for example, 1/1/2016 12:00 AM)
Use the format function (for example, ="January 1st 2016 at 12:00 AM")
Click on "Format Cells" in the "Home" tab and select "Custom." Then enter a custom date-time format in the box that pops up.

Learner's Ratings

4.4

Overall Rating

Reviews

MANYA DWIVEDI

Sir thank you for making this platform It is excellent no words to explain

Patel Parth

It excellent

Rizwan Ahmad

very nice course

gunjan agrawal

The course is really very useful as it provides you with practical .All over teaching is good but it is showing error when I am applying for certificate and also learnvern forums are not opening .

Rishi

Hi! Sir my name is Rishi. I am very happy with your website builder that he thought like this. Thank you for such a noble thought, thank you very much...

Aditya Sharma

I wanted to learn basics of excel before starting my MBA journey and these lessons are really helpful for the same.

Anuj Jehta

VERY GOOD

Gurdeep singh

good

Gurdeep singh

my name

Chirag Hadiyal

This course is very good explain by sir

Recommended Courses

Free हिन्दी

MS Word Course

77254

4.4 Enroll For Free

Free हिन्दी

Spoken English Course

549328

4.7 Enroll For Free

Free हिन्दी

Customer Service, Customer Support and Customer Experience

10341

4.6 Enroll For Free

Free English

Soft Skills - Essentials to Start Career in English

17934

4.7 Enroll For Free

Free हिन्दी

Career In Sales

13761

4.8 Enroll For Free

Formatting Date-Time in MS Excel

Start a new search

Overview

How do you format date and time in Excel?

How do I use the Format function to format date-time in MS Excel?

Is there a list of shortcuts for formatting date-time in MS Excel?

How can I preview my formatting changes before applying them?

What are the different ways to format date-time in MS Excel?

Learner's Ratings

Reviews

MANYA DWIVEDI

Patel Parth

Rizwan Ahmad

gunjan agrawal

Rishi

Aditya Sharma

Anuj Jehta

Gurdeep singh

Gurdeep singh

Chirag Hadiyal

Recommended Courses

MS Word Course

Spoken English Course

Customer Service, Customer Support and Customer Experience

Soft Skills - Essentials to Start Career in English

Career In Sales

Course Content

Menu in Excel

How to use LearnVern

Quick Access Toolbar

Formula Bar in Excel

Status Bar in MS Excel

Navigation in MS Excel

Shortcuts in MS Excel

Format Painter in MS Excel

Data Entry in MS Excel

Autofill in MS Excel

Data Entry for Date-Time in MS Excel

Undo-Redo in MS Excel

Comments in MS Excel

Saving File in MS Excel

Creating Formula in MS Excel

Copy Formula in Excel

Till Date Formula in MS Excel

Pct Calculation in MS Excel

Absolute in MS Excel

Sum Average in MS Excel

Other Common Functions In MS Excel

Formatting Fonts in MS Excel

Adjusting Rows & Columns in MS Excel

Alignment in MS Excel

Formatting Borders in MS Excel

Formatting Numbers in MS Excel

Formatting Date-Time in MS Excel

Conditional Formating in MS Excel

Formatting Tables in MS Excel

Formatting Shapes in MS Excel

Resizing Row & Column in MS Excel

Hide-Unhide Row and Column in MS Excel

Copy, Move, Insert Data in MS Excel

Find Replace in MS Excel

Printing in MS Excel

Page Break Preview in MS Excel

Page Setup in MS Excel

Creating Charts in MS Excel

Types of Chart in MS Excel

Formatting Charts in MS Excel

Chart Elements in MS Excel

Sparklines in MS Excel

Freezing Workbook in MS Excel

Splitting Sheets in MS Excel

Outline in MS Excel

Manage Multiple Workbook in MS Excel

Working with Sheets in MS Excel

Copy & Delete Sheets in MS Excel

Use of Formula in Worksheet

Edit Links in MS Excel

If Condition in MS Excel

VLOOKUP in MS Excel

VLOOKUP Exact in MS Excel