SubJeff on 12/6/2011 at 19:37
I've a spreadsheet that has date as the first column and I need to sort to the sheet by date.
The first column format is DD/MM/YYYY and I've made sure of this on the whole column and on some of the cells that seem to be misbehaving.
The problem is this - when I select the entire sheet and try to sort by date it seems to work but if I scroll down the sheet I can see that there are some 2010 dates mixed in with the 2011 dates.
Therefore I suspect that the sort by "oldest to newest" is doing it by the date the data was entered, which admittedly is not in order.
So how do I sort it all by this column? I've tried selecting in different ways but no luck.
Al_B on 12/6/2011 at 22:17
(Original response / question deleted)
Are you sure that every entry in the date column is actually a date? Excel is pretty good normally at interpreting dates so I'm very surprised that if the column is being correctly sorted that it mixes 2010 and 2011 dates together. Are you able to reproduce the problem with a few dates from the same date range?
SubJeff on 16/6/2011 at 22:57
Sorted it. Sort by column A then let numbers be considered.
