Sep 09 2020 02:50 AM
Hello,
I have downloaded dates from a file and Excel reads the data as text. I have tried formating the cells to be a date but Excel still won't see the format as a date. I know there is a way to format the date but I can't remember.
Can someone help me?
Sep 09 2020 03:09 AM
Just changing format won't help. If dates are in column, you may select them, Data->Text to Columns and on third step of the wizard mark type of the column Date and select in which format they are now (e.g. MDY)
Sep 09 2020 03:16 AM
Thank you for your response but I cannot find the wizard mark … could you help me again?
Sep 09 2020 04:02 AM
Select the column and Data->Text to Columns. Wizard window appears
Click Next, Next and on third step
Result is
(my dates are in ISO format)