» Change slash separator in date with period in Microsoft Excel
If you are one of those people who love to use period instead of / and would like to change the default setting for the date format, perform the following steps:
From Windows, choose Start, Settings, Control Panel, Regional Options.
Select the Date tab. In the Date separator box, change the slash (/) to a period (.).
Click Apply and OK.