In article , ?B?dGlnZXJl?= wrote:
-I am trying to sort according to month - I have split the date - m/d/yr -
into 3 separate columns - I can sort to day and year - but with month I get
august appearing between november and december ...??? and can't get it to
follow september ...

I'm not sure exactly what you are trying to do here (as I would expect
august before september and can't think how it would end up between
november and december :) ) but in general, there is an option to use a
'custom list' for sorting. Check out the help file for how to set this up
and see it once you have.

That said, if you choose data/sort/options then click on the drop down box
showing 'normal', you could find that your requirements have been
anticipated. :)

Enjoy.