| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Sort Error
I have a list of state abbreviations in a pivot table:
CAL KAN MON TEX When I sort them A to Z in a pivot table, I get the following result: MON CAL KAN TEX What is happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Sort Error
Spaces (or other non-printing characters)?
-- David Biddulph "cory" wrote in message ... I have a list of state abbreviations in a pivot table: CAL KAN MON TEX When I sort them A to Z in a pivot table, I get the following result: MON CAL KAN TEX What is happening? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Sort Error
Hi Cory,
Questions: 1. Do you have a custom list set up in your Excel installation? 2. Are you sorting using the PivotTable sort tools or are you sorting using the quick sort buttons on the standard toolbar or the standard Sort dialog box? 3. What version of Excel are you using? "cory" wrote: I have a list of state abbreviations in a pivot table: CAL KAN MON TEX When I sort them A to Z in a pivot table, I get the following result: MON CAL KAN TEX What is happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort in a Pivot Table | Excel Discussion (Misc queries) | |||
| sort of pivot table | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Pivot Table Sort Error | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Hybrid Mode
