Why do you need it formatted if all you're doing is sorting by?

Format column A to "mmmm" to see just the months in that column then hide B if
you don't want to see the numbers

I have no trouble sorting on column B tested with the dates you supplied below.

Select both columns before sorting by the MONTH column

I hope you're not using WORD 97.........this is an Excel news group.


Gord

On Sat, 20 Oct 2007 11:22:34 -0400, Crackles McFarly
wrote:

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?