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

  • Add Time To A DateTime Value In Excel

    add minute to a date time value in excel, add hour to a date time value in excel, add second to a date time value in excel, add time value to a datetime in excel
    ,excel formula to add time to a datetime value

    Share The Knowledge
  • Fit Image Inside A Shape In Excel

    In this post we will see how to fill a shape with image in excel. I am going to explain […]

    Share The Knowledge
  • Extract Substring Between Parenthesis In Excel

    get substring between the bracket in excel, excel formula to get value from within parenthesis, get numeric value from inside bracket in excel, get data from within bracket in excel

    Share The Knowledge
  • Show Text And Numeric Value In A Cell In Excel

    The post demonstrates how to show a numeric value and a text description in a single cell only. We can […]

    Share The Knowledge