Some people like to use a period (.) when they separate their dates instead of a slash (/). For example, you might prefer 4.15.2012 instead of 4/15/2012. If you're tired of creating a custom number format that accommodates your desired date format, try changing Windows' default date separator.
To modify your default date separator:
- Click the Start menu on your Windows operating system and open the Control Panel.
- Double-click on Regional And Language Options to open the Regional And Language Options window.
- Click on the Regional Options tab and click the Customize button to display the Customize Regional Options window.
- Select the Date tab and choose the period from the Date Separator dropdown list.
- Click Apply and OK to make the change.
Important: If you change your default Windows setting to a different date separator, the change applies to all programs — not just Excel.
Learn this and more by checking out our Certified Microsoft Office Courses!