Excel Tip: Change Default Date Style
The style that Excel uses to display your date is actually controlled outside of Excel, in the Windows Control Panel.
Follow these steps to customize the default date style to your liking:
- Click the Start button on your Taskbar and choose Settings, Control Panel.
- Double-click on the Regional Settings icon, and the Regional Settings Properties window will appear.
- Click the Date tab, and you will see an indicator for Short date style. This is where Excel is getting its standard setting for displaying the date.
- Choose from several short date styles available in the drop-down list. If the style you prefer is not on the list, choose a style that is close to what you want, then make any changes you want. For example, you can make a two-digit year into four digits by changing the "yy" to "yyyy" or you can substitute dashes or periods for the slashes that separate the month from the day and year.
- While here, you can customize the Long date style in the same manner.
- Click OK when you have finished entering your preferred date style(s).