Two points to remember when you sort.
Firstly, remember to select the range of rows and columns which you wish to
sort; it isn't advisable to allow Excel to guess the range.
Secondly, you may be offered the choise of whether to treat text which looks
like a number as a number; be careful how you answer that.
--
David Biddulph

"Pete" wrote in message
...
I have a large list of dates that I need to sort by only the month and day
(e.g. 9/14) and do NOT want or need the year. I had set up a helper column
originally to do the sort but about two weeks ago any date I added will no
longer sort. My formula appears intact (=text(a2,"mm/dd"). I've even tried
to
manually enter the date in the helper column which I normally hide but the
date will then appear as "14 Sep". Obviously there is something very
simply
staring right at me to correct this but I'm not seeing it.