LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - replace numbers with a text vinstream Excel Discussion (Misc queries) 1 April 6th 10 10:48 AM
Pivot table treating numbers as text in value field Rune Wentzel Helms Excel Worksheet Functions 2 July 3rd 09 09:15 AM
Displaying Text, not numbers, in Pivot Table Longtime listener first time caller New Users to Excel 2 March 8th 07 09:44 AM
Making Text into Numbers, for Pivot Table Cubes traceye Excel Worksheet Functions 0 January 31st 07 11:04 AM
Pivot Table keep apart cells text that I've formatted as numbers Paulo Bevervanso Excel Worksheet Functions 2 September 21st 05 08:45 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"