Surely that would work only if column A contained dates, and if it did then
A should already sort OK? If A doesn't sort correctly, it is presumably
text?
--
David Biddulph

"Mike H" wrote in message
...
Hi,

Maybe this. With your dates in A1 down put this in B1
=Month(a1)
drag down as required and select both columns A & B and sort on B
You can then hide B if you want.

Mike

"Cam" wrote:

?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