On Sat, 20 Oct 2007 07:57:23 -0700, Gord Dibben <gorddibbATshawDOTca
sayd the following:

In an adjacent column enter =MONTH(A1) and drag/copy down.

Sort by that column.


Gord Dibben MS Excel MVP


That gives a number result, like 12 in place of December.

Also I cannot sort, the function doesn't work on the MONTH(A1)

Is their some setting that is not allowing me to Sort?
I'm using WORD 97 btw.

thanks.


On Sat, 20 Oct 2007 09:06:52 -0400, Crackles McFarly
wrote:

On Sat, 20 Oct 2007 05:46:00 -0700, Mike H
sayd the following:

July-60
July-71
December-73
July-83
October-83
July-86
August-87
June-90
August-90
August-90
March-91
July-92
July-92
August-92
September-92
September-92
April-93

I need to Sort by the MONTH and strip the YEAR.
Then I need to simply Sort the column by Month only.

I don't know if that makes any sense.
thanks.

Insert a helper column next to your dates and with the dates in (say) A1 down
put this in b1 and drag down

=TEXT(A1,"mm/dd")

Select your dates and this helper column and sort by the helper column.

Mike

"Crackles McFarly" wrote:

I have a large amount of data, it's simply dates.
example
4/4/92
1/3/2007
5/6/1955
etc

I want to display ONLY the month and then SORT only by the month.

Basically I want to ignore the YEAR in the date and then sort.

I've tried this several ways BUT it will not sort the numbers even if
I format them.

help?