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.

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.

I always select the range of rows and I always check to treat (what looks
like) a number as a number.

Still doesn't work. Also, I'm not keen on setting up two helper columns
(Andy's suggestion) as it seems a waste when one will (at least used to) do
it.

Any other thoughts?

Make it easier on yourself: make two helper columns with MONTH(A2) and
DAY(A2), then sort on those columns.

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"Pete" wrote:

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.