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.
KIZZA94
Copper Contributor
What is a support column?
Benny_1857
Jan 19, 2022Brass Contributor
just a column ^O^
Even if you have the UK date, use fomular in another column to transfer it to the one you need. Then filter this column.
Maybe cannot solve your shutdown problem, but filter it first.
Even if you have the UK date, use fomular in another column to transfer it to the one you need. Then filter this column.
Maybe cannot solve your shutdown problem, but filter it first.