Tip Printed from ExcelTip.com
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.