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 the 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 the date format to a 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 with the date 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.