Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting pivot tables - text / date confusion
I have a pivot table of students taking courses, which I need to sort by
surname. One of the students' surname is May, and Excel always puts this at the top of the list, before Adams & Anderson etc. It's the same if I change the source data so that the person's name is April or December. I've tried formatting it as text, but this doesn't seem to have any effect. Any ideas gratefully received. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting in Excel 2000 Pivot Tables | Excel Discussion (Misc queries) | |||
pivot tables by date range | Excel Discussion (Misc queries) | |||
Sorting in pivot tables | Excel Discussion (Misc queries) | |||
Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
Sorting data in Pivot Tables | Excel Discussion (Misc queries) |