Convert Date Format to dd/mm/yyyy in Excel

Ask a question
Microsoft Excel is a software that allows you to create efficient spreadsheets for business of personal use. They permit you to stay organized while managing large amounts of data, which can be organized in a range of ways.

One popular way to organize this data is by date. Excel comes with a default date format, mm/dd/yyy, but you can always choose to change the date format, to dd/mm/yyy, for example.

Change Excel Date Format from mm/dd/yyyy to dd/mm/yyyy

To change the date display in Excel, go to Format Cells > Custom, and enter dd/mm/yyyy in the available space.

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


Image: © Microsoft.

How To Copy Data from One Excel Sheet to Another Using a Formula
How To Auto Transfer Data from Master to Sub Sheets in Excel