Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - sorting numbers
When using pivot tables, we have a task number for each job and have tried
various formatting options (text, number). The taks number generally is up to 3 digits and 1 decimal place. The pivot table sorts the single digits (1-9) 1.0 10.0 11.0 2.0 20.0 21.0 etc. Our solution to this was to start the task numbers at 10 and use only minimum of 2 digits. It's been several versions of Excel since we created our file and now revamping to meet current needs. Is there a workaround so we can use 1-9? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - sorting numbers
Your job numbers are not numbers. They are Text. You have 2 options. One is
to convert them to actual numbers prior to loading them into the pivot table. this is different from reformatting the numbers. You actually need to convert them to numbers. The other is to reformat the numbers to include leading zeros. 001.0 instead of 1.0 -- HTH... Jim Thomlinson "BW" wrote: When using pivot tables, we have a task number for each job and have tried various formatting options (text, number). The taks number generally is up to 3 digits and 1 decimal place. The pivot table sorts the single digits (1-9) 1.0 10.0 11.0 2.0 20.0 21.0 etc. Our solution to this was to start the task numbers at 10 and use only minimum of 2 digits. It's been several versions of Excel since we created our file and now revamping to meet current needs. Is there a workaround so we can use 1-9? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting pivot tables - text / date confusion | Excel Discussion (Misc queries) | |||
Sorting in Excel 2000 Pivot Tables | Excel Discussion (Misc queries) | |||
Why do pivot tables not read numbers that are copied and pasted | Excel Discussion (Misc queries) | |||
Sorting in pivot tables | Excel Discussion (Misc queries) | |||
Sorting data in Pivot Tables | Excel Discussion (Misc queries) |