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.
SergeiBaklan I tried both starting in safe mode as suggested and setting 'Calculation Options' to Manual but it still shuts down when I try convert them using text-to-columns. I can't repair or update office because I am using a work computer which is controlled by the organisation.
If only text-to-columns will cause shutdown, would you try insert a support column or add a support column at last with formular. Then filter the support column?
- What is a support column?
- 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.
