Change date format in Excel: to dd/mm/yyyy, mm/dd/yyyy

Change date format in Excel: to dd/mm/yyyy, mm/dd/yyyy

Excel spreadsheets permit you to stay organized while managing large amounts of data, which can be organized in a number of ways. One popular way to organize this data is by date. Excel has a default date format of mm/dd/yyyy, but you can always choose to change the date format, to dd/mm/yyyy, for example. In this article we will show you how to change date format in excel to dd/mm/yyyy, and also how to revert it to mm/dd/yyyy.

How to change Excel date format?

From mm/dd/yyyy to dd/mm/yyyy

To change the date display in Excel follow these steps:

  • Go to Format Cells > Custom
  • Enter dd/mm/yyyy in the available space.

The dates listed in your spreadsheet should be converted to the new format.

From dd/mm/yyyy to mm/dd/yyyy

  • Go to Format Cells > Custom
  • Enter mm/dd/yyyy in the available space.

How to change date format to general numeric format?

You may also need to know how to convert the date form a date format into a general format, for example 14/01/2022 > 14012022.

You can use this formula:

=TEXT(A2,"mm/dd/yyyy")

Alternatively:

  • Right click on the cell which has the date that you want to convert into a number and then go to the Format Cells menu.
  • In the Format Cells, in the Number tab, select General from the category list. 
  • Select OK. The date should now be displayed as a numeric value without the date format. 
Need more help with Excel? Check out our forum!

Excel