Forum Discussion
Excel does not convert numbers to date
Your default date format is dd/mm/yyyy.
If you enter 1/2/2021 it shall be recognized as date (01 Feb 2021). If you enter 1.2.2021 it doesn't match your date format and Excel takes it as text ( like aas,djas, Excel also doesn't recognize it).
SergeiBaklan I am running Windows 10 64bits see the attached Geo and date format settings.
Your default date format is dd/mm/yyyy.
If you enter 1/2/2021 it shall be recognized as date (01 Feb 2021). If you enter 1.2.2021 it doesn't match your date format and Excel takes it as text ( like aas,djas, Excel also doesn't recognize it).
SergeiBaklan thanks for your help, I have switched the OS date format for French (Switzerland) and it is now capable of recognizing even 1.2 as February 1st successfully
David_Sword Great to know you sorted this out, thank you for the update