Thread: Sort problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Sort problem

Create a custom list of month names, ToolsOptionsCustom Lists, then sort
using that list, DataSortOptions and then pick from the list.

--

HTH

Bob

"Emece" wrote in message
...
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.-