Sort problem

E

Emece

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.-
 
B

Bob Phillips

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top