Forum Discussion
excel date conversion
hi help me to convert date 01.01.2020
If such texts are in column, you may select it, Data->Text to Columns, on third step of the wizard select date and DMY or MDY depends on which format is assumed in the source.