Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 29th 08, 09:11 PM posted to microsoft.public.excel.misc
BW BW is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 49
Default 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   Report Post  
Old January 29th 08, 10:51 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,941
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting pivot tables - text / date confusion malcomio Excel Discussion (Misc queries) 4 January 21st 08 02:52 PM
Sorting in Excel 2000 Pivot Tables LPS Excel Discussion (Misc queries) 1 December 8th 05 09:25 PM
Why do pivot tables not read numbers that are copied and pasted B_4j Excel Discussion (Misc queries) 1 June 23rd 05 11:10 PM
Sorting in pivot tables Andy Excel Discussion (Misc queries) 0 May 25th 05 03:41 PM
Sorting data in Pivot Tables gramos14 Excel Discussion (Misc queries) 2 January 18th 05 12:07 AM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017