SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 705
- Office Version
- 365
- Platform
- Windows
I should know this. I have a column (AA) with date/time in this format: 7/1/2008 12:23:01 PM
I have another column where I want the month and year so I do =(text(aa2,"mmm-dd") and for this example it shows up as Jul-08.
But when I try sort sort the column or do a pivot table it all sorts in alphabetical order. I checked the cell format for the column and it looks ok - I selected MAR-01.
What gives?
I have another column where I want the month and year so I do =(text(aa2,"mmm-dd") and for this example it shows up as Jul-08.
But when I try sort sort the column or do a pivot table it all sorts in alphabetical order. I checked the cell format for the column and it looks ok - I selected MAR-01.
What gives?