I have a worksheet with dates (dd/mm/yyyy) in column A. The downloaded dates were not ordered the way I wanted them. I made certain that the cells were formatted as dates. I was amazed to discover that “data/sort” sorted by day and month but ignored the year. I overcame the problem by segregating the sheet into year sections with empty rows in between and then sorting by selecting and sorting each section.
I’ve attached a file showing the data sorted they way I want it (October 2005 – February 2006) and the way that Excel sorts it.
Is this a ‘known bug’ or do I have an obscure preference set somewhere that I cannot find?
Thanks,
baumgrenze