Feb 18 2020 07:44 AM
Feb 18 2020 07:49 AM
Feb 18 2020 11:37 AM
To permanently change the Date Format to mm/dd/yyyy:
1. Type in Control Panel on your system
2. Click on Change date, time, or number formats
3. Click on Additional Settings
4. Select Date tab
5. In the Short Date box, type in dd/mm/yyyy
6. Click OK
After doing this, all the dates including in Excel spreadsheet will be displayed in mm/dd/yyyy format