Hi,
I'm trying to sort a really long list of rows (11000) by date order. The date is in column d and there's info in each of columns a to p. The problem is that when I sort them I get them as follows:
1st Apr
1st Aug
1st Dec
1st Jun
etc.
Basically it's not treating them as dates. I've formatted the column so that excel should know they're dates, but don't know what else to try.
I'm using excel 2000.
Any help would be much appreciated!
Julia