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.

Tod wrote:

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