Forum Discussion
Dates not sorted chronically for all dates in cell
Basically it seems to apply for some but not others. (I have uploaded just the affected section into a test document)
Basically no idea why it is not sorting all the dates chronically just it appears the first half of them.
3 Replies
PWWRB That's because the "dates" are in fact texts. Easiest would be to select the entire first column and use Text-to-columns on the Data ribbon to transform the texts to real dates. Click your way to Step 3 of 3 (step 1, Delimited, step 2 uncheck all delimiters) and select the data type Date with DMY specifying the format. Press finish and you are left with a column of real dates that will sort properly. Repeat for the second column.
