Forum Discussion
Dates formatted as GENERAL
I have a large spreadsheet (downloaded from bank statements), where the first column has the dates, formatted like 29.05.2020. It is formatted as GENERAL. When I change the cell format to DATE, it ...
Most probably you have texts in the column. You may try to select it, Data->Text to Columns and on the third step of the wizard select Date and DMY. Be sure column is not split.