View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LPS
 
Posts: n/a
Default Sorting in Excel 2000 Pivot Tables

In an Excel 200 Pivot Table I have a column of text data which appears as
follows: P1-10, P1-2, P1-20, P1-5.

Is there anyway I can re-sort this data so that it appears as follows:
P1-2, P1-5, P1-10, P1-20.

Thx,
--
LPS