03/01/05 is an ambiguous format. Format the cells as something unambiguous,
like dd mmm yyyy, and then you'll see what dates you are really dealing
with.
--
David Biddulph

"Pammy" wrote in message
...
When I sort dates, they are sorting in order. The format is a date format
03/01/05.
When I choose assending order, they start out ok, but then get mixed up:
3/01/05 - 03/06/05, 03/02/05, and even the end 05/01/04,any idea?