How to change the default Date format in Excel (and also for all the dates of your computer).
- First, it's not an Excel setting but a Windows setting
The default Date format in Excel in managed by Windows
- Go to the Region Settings
There is a trick to open en Region Settings of Windows with a shortcut
How is displayed a date in Excel?
By default, when you insert a date in a cell, the default delimiter between the day, the month, and the year it's the slash.
And this, even if you write your date with dashes. Excel automatically replaces the dashes with slashes 🤔
Step-by-Step Instructions to Modify Default Date Format
If you want to customize the default display, you must change a Windows setting.
- Open the Regional settings of Windows
- You can open it quickly with the command line intl.cpl in the Windows Search box
- Click on the dropdown button for the short or long date.
- When you press the drop-down button, you display other date formats
- But the choices is limited (there is no option to display dates with dashes for example 😕)
Create your custom date format for Excel
- To Create your custom default date format, you click on the button Additional Settings
- Go to the Date tab
- Change the custom date format to dd-MM-yyyy (explanation for the code here)
And without restarting Excel, neither your computer, all the dates format in your worksheets has the dash for date delimiter 😉
- You don't change the settings of the default date display ONLY for Excel
- ALL THE DATES of your computer are impacted by this update😲
- So, take care if you change the date format of your computer. It could generate bad side effects for other applications.