Forum Discussion
Incorrect date format when using text to columns
Hi,
I have a problem sorting by date, i tried the Cell Format thing and also the Text to Columns to identify cells as Date cells , but nothing worked still cells are sorted incorrectly.
Anyon...
Text to Column also works if ignore the time. Split column by space, on the third step select MDY for first column and skip another one.
Result could be placed at the same column or copied to another one