Sort problem
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.- |
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.- |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com