Excel recognizes a number as a date by its date format, which uses a slash (/) as a separator, for example, 1/25/2004 is recognized as a date by Excel.
To change the default setting for the date format:
1. From the Windows Start menu, select Settings, Control Panel, and then Regional and Language Options.
2. In Regional Options, select Customize.
3. Select the Date tab, and in the Date separator dropdown list, change the slash (/) to a dot (.).
4. Click Apply and then click OK.
Screenshot // Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.