From: Emece on
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
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.-