It sounds as if you have entered the data as text, rather than as dates
appropriately formatted. If you put them in as dates they will sort
successfully.
You can check by using =ISTEXT and =ISNUMBER. If they are real dates,
=ISNUMBER will be TRUE.
--
David Biddulph

"Cam" wrote in message
...
?ello,

I have column by month in this format: yy-mmm (08-Mar, 08-Apr, etc). But
when I sort the column it is not in the order of Jan to Dec instead by the
first letter of the month. Is there a way to sort it so it recognize the
month instead. Thanks