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.