Forum Discussion
KIZZA94
Jan 19, 2022Copper Contributor
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...
- Mar 15, 2022
SergeiBaklan Brilliant, that second option worked! Thank you very much.
Riny_van_Eekelen
Jan 19, 2022Platinum Contributor
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.
- Benny_1857Jan 19, 2022Brass ContributorIt's true, in PQ, you could set up local datetime format.
- KIZZA94Jan 19, 2022Copper ContributorI am using a work computer so cannot download any software.
- Riny_van_EekelenJan 19, 2022Platinum Contributor
KIZZA94 Power Query is integrated in Excel since 2016. So, no download needed if you are a recent Excel version.