Date Formatting

You are here:
< Back

By default, excel stores the date as a number and it gives you the flexibility to change the appearance of the date as per the requirement.

Excel has an umpteen number of predefined date formats that are available for use and also we could create our own customized date formats.

Below is an example where we could see different formats for the same date.

different date formats in excel

To apply the format to a date, select the date and click on the Number Format drop down and select “More Number Formats” or you could press keyboard shortcut Ctrl+1 to open the Format Cells menu.

how to apply different date format in excel

After you get the menu for Format Cells , select  Date from the box at the left and select a format from a large number of date formats available here by scrolling the format box.

menu showing different date formats available in excel

And press OK.

You could see below that we have applied the desired format.

selected format is applied

Custom Date Format

Do not worry if you do not get the date format that matches your requirement, excel offers you a lot of other custom formats where you could modify the formats as per your requirement.

custom date format in excel

Select the custom from the menu at the left and select date format from the menu at the right side.

There is another concept of custom format strings which we have explained in a different section.

Random Posts