To modify your default
date separator ( i.e. from 5.15.2012 to 5/15/2012):
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 drop-down
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.
