View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Compass Rose Compass Rose is offline
external usenet poster
 
Posts: 30
Default Pivot table sorting

Excel 2003

I have a column of numbers in a pivot table that is a concatenation of 2
columns.

224003
225012
226009
230101
230205
230807
230904
231016
301013

After sorting, stripping out packed zeros and splitting back into 2 columns,
the columns look like this:

224 3
225 12
226 9
2301 1
2302 5
2308 7
2309 4
231 16
301 13

I would like the columns to look like this:

224 3
225 12
226 9
231 16
301 13
2301 1
2302 5
2308 7
2309 4

Is it possible?

TIA
David