Yes, in 2007, you can drop down the sort & filter arrow and choose Custom Sort. In the Order field, select Custom List and it will bring you a list of choices, one of which is by month. Hope that helps.
Sorting Month Names in Calendar Order
I have a list of data (for learning purposes) where one of the fields is the name of the month, i.e., a text field. If I sort on this field, it sorts months in alphabetical order.......April, December, February, etc. I would like it to sort in calendar order....January, February, March, etc.
Is this possible in Excel? in either '03 or '07?
I know I can do it in a pivot table, but I want to change the raw data to sort in calendar order.
Thanks
Is this possible in Excel? in either '03 or '07?
I know I can do it in a pivot table, but I want to change the raw data to sort in calendar order.
Thanks
- Status
- Not open for further replies.
1 - 4 of 4 Posts
Excellent! I was trying to input a formula, but I knew there had to be an easier way!!!
Glad it worked. :up: You can mark this as solved by using the button at the top of the thread.
1 - 4 of 4 Posts
- Status
- Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
