Sorting in Excel 2000 Pivot Tables

L

LPS

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,
 
D

Dave Peterson

How about change the underlying data to look more like:

p1-02
p1-05
p1-10
p1-20

Then your sorting will become much easier.
 
Top