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.
- you may ask sysadmins to repair
- one more, copy/paste this column into new file and Text to Columns it. If works, that means the problem in formulas which reference this you column, not in Text to Columns itself.
SergeiBaklan Brilliant, that second option worked! Thank you very much.
KIZZA94 , you are welcome
