how to change date format in excel to mm/dd/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.