In one huge Excel file, I have two different "date formats", for example 17.08.2022 and 2022-08-17. These dates are all written in one column, I want to write all of them in the same format (preferably in this format, 17.08.2022) and rewrite them in the same column. How should I do it? Please have it in mind that I am not good at writing code :(.
1 Answers
I guess the 17.08.2022 format are not actual dates but text. Anyway you can try to highlight the column -> Data -> Text to Columns -> Next -> Next -> Date: DMY > Finish.
Related