Forum Discussion
Sorting dates in Excel from oldest to newest is not working
Hi JK,
Thanks for your reply. I am actually opening an Excel file and not a CSV file. I tried to split, as you said, and eventually it may work, but too much of a hassle as I have to download these files on a daily basis. I just have to find an easier solution 😅 But thanks!
Your data does not contain "a date series" as far as Excel is concerned. Instead, it contains a text series where the text contains formatted datetimes. (Clue: The data is left-aligned. By default, Excel aligns numeric values—including dates and times—to the right.)
See the attached workbook for a basic way of handling this. But these techniques still require manual intervention.
"I have to download these files on a daily basis"
The recommendation to use Power Query instead is valid.
How to easily automate boring Excel tasks with Power Query!