Month sorting

  • Thread starter Thread starter swizz182g
  • Start date Start date
S

swizz182g

i need to be able to sort a month column by month order instead of
alphabetical order

Is this possible?
 
When I want this I do not type the month names
Rather I enter the first day of the month (1/5/2008 for May or 5/1/2008 if
in USA) and format the cells either mmm (to get Jan, Feb...) or mmmm (to
get January, February....)
These values sort perfectly
best wishes
 
Yes it is possible ,, when sorting, go to Data, Sort then click on the
Options button ,,, then choose the months ,, this sorts the data by month
 
Helpful posting advice here... http://www.cpearson.com/excel/newposte.htm
To answer your question...
1. Make up a list of months on a worksheet.
2. Go to Tools | Options | Custom Lists and import and add.
3. When sorting you must specify the custom list - click the "options"
button in the Sort dialog box to do that.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - check out Special Sort)



"swizz182g"
wrote in message
i need to be able to sort a month column by month order instead of
alphabetical order
Is this possible?
 
Back
Top