A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Numeric sort order problem (7.2 perceived as 7.19)



 
 
Thread Tools Display Modes
  #1  
Old January 14th, 2009, 07:17 PM posted to microsoft.public.word.tables
Don Palmer
external usenet poster
 
Posts: 1
Default Numeric sort order problem (7.2 perceived as 7.19)

I frequently have to sort tables on columns that are populated with paragraph
numbers taken from large documents. How do I sort so the order is correct,
e.g., 7.2 comes before 7.19. I know this issue exists in other Office
applications. How can this be corrected without "padding the numbers with 0's
(7.02 instead of 7.2)?
  #2  
Old January 14th, 2009, 09:03 PM posted to microsoft.public.word.tables
Klaus Linke
external usenet poster
 
Posts: 401
Default Numeric sort order problem (7.2 perceived as 7.19)

"Don Palmer" wrote:
I frequently have to sort tables on columns that are populated
with paragraph numbers taken from large documents.
How do I sort so the order is correct, e.g., 7.2 comes before 7.19.
I know this issue exists in other Office applications. How can this
be corrected without "padding the numbers with 0's
(7.02 instead of 7.2)?



Hi Don,

In the Sort dialog, go into the options, field delimiter, and enter a full
stop (.).

Say you have the numbers in the first column, you'd set that as the sorting
key in the Sort dialog, and choose the type ("numbers"), just as you've
probably already done before.

But below that, under "With:", you should now see "Field 1" and "Field 2" in
the dropdown list.
If you don't, sort the table once, and look in the "With"-dropdown again...
Sometimes, Word seems to need a first look at what's in the column, to
figure out what fields there are.

Sort by column 1, field 1 (= the number in front of the dot), then by column
1, field 2 (= the number after the dot).

Regards,
Klaus

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.