Sorting Numbers as Text in Pivot Table

[Tod]

I've read a few different posts in the newsgroups regarding this topic,
but I guess I need to have it spoon fed to me to understand it. So here
goes:

The first column of my pivot table is a set of numbers. I want them to
appear like this:

1.1
1.2
1.3
1.4

etc

1.9
1.10
1.11
1.12

etc

2.1

But they are sorted like numbers, like this:

1.1
1.11
1.12
1.3
etc

How can I get the pivot table to sort them the way I want?

tod

 

[Tod]

More on that.

I figured out two formulas that, when sorted along with the number,
gives me the order I need.

If I first sort on the Int of the number, then the Len of the number,
and then the number itself, they come out in the correct order. But now
what? How do I incorporate that algorithm into the pivot table?

tod

 

[Dave Peterson]

Have you thought of changing your input data to look more like:

1.00
1.01
1.02
1.03
....
1.10
1.11

It would make life much easier.