Sorting Numbers as Text in Pivot Table
 

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

Sorting Numbers as Text in Pivot Table
 

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

Sorting Numbers as Text in Pivot Table
 

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