View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default 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