» Change slash separator in date with period in Microsoft Excel

CATEGORY - Excel Dates , Excel Keyboard Shortcuts VERSION - All Microsoft Excel Versions

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.