Forum Discussion
Excel keeps crashing when trying to convert dates using text to column
I have a large excel file containing over 12,000 rows of data. I cannot filter the data by date because excel doesn't recognise the UK dates as a date format and it cant be changed using the change f...
SergeiBaklan Brilliant, that second option worked! Thank you very much.
KIZZA94 Have you considered using Power Query (if you are not on a Mac, that is)? Would also be good to know exactly how the "dates" look like before you try to transform them into the UK format.
It's true, in PQ, you could set up local datetime format.
