Thread: Month sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Month sorting


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?