Sort problem
in [General]
|
Prev: Hard to select first worksheet tab
Next: How 2 sort an autosum total list after adding items 2 autosum item
From: Emece on 30 May 2010 17:03 I have the months of the year in one column. I need Excel to sort the months, but according to calendar. I need January, February, March and so on. But if I choose to order them in ascending order, it shows: April, February, March... How do I solve this problem? Thanks in advance. Regards, Emece.-
From: Bob Phillips on 30 May 2010 18:04
Create a custom list of month names, Tools>Options>Custom Lists, then sort using that list, Data>Sort>Options and then pick from the list. -- HTH Bob "Emece" <Emece(a)discussions.microsoft.com> wrote in message news:BC34B54F-A191-44C5-A2B0-862702B55174(a)microsoft.com... >I have the months of the year in one column. I need Excel to sort the >months, > but according to calendar. I need January, February, March and so on. But > if > I choose to order them in ascending order, it shows: April, February, > March... > How do I solve this problem? > > Thanks in advance. > > Regards, > Emece.- |