Thanks Dave. Works fine now. Appreciate the help.

"Dave Peterson" wrote:

Maybe you can change the labels to make it easier to sort

00-04
05-07
07-10
10-12
12-99

Another option that worked for me under light testing...

Tools|Options|Custom lists
I added the list in the order that I wanted and my newly created pivottable came
out in that order.

les8 wrote:

I have a pivot table that has columns "<5", "5-7", "7-10", "10-12"
and "12". However, when the pivot table comes up, they are out of
order (<5, 12, 10-12, 5-7, 7-10). I can manually rearrange the
columns using the order option, but is there any way to get them to
come out in the correct order? Thanks very much for your help.

--

Dave Peterson