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.
I am using a work computer so cannot download any software.
KIZZA94 Power Query is integrated in Excel since 2016. So, no download needed if you are a recent Excel version.
