Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Nelson Nelson is offline
external usenet poster
 
Posts: 9
Default Sorting a Table by Number

In a MS Word 2003, SP3, 6X1 table I place the following values one per row
4E
2E
3E
E
1E
5E

When I go to Table Sort "number" "ascending" the table will not sort.
If I use Text instead of number it will. Now, If I change the letter E to
any other letter in the alphabet, using B as an example, the table will sort
by number giving me the following result

B
1B
2B
3B
4B
5B

Any thought or ideas on this would be appreciated.

Thanks,
Nelson
  #2   Report Post  
Posted to microsoft.public.word.tables
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default Sorting a Table by Number

Very interesting. It's broken in Word 2007, as well.

My guess would be that Word thinks that the E items are in incorrect
scientific format, and it's confused because it's not designed to handle
them unless they're in standard format. It expects to see a + or - after the
E, but doesn't, so decides that the numbers are improperly formatted (e.g.,
4E+5 would be correct).

I notice that if I add + or - and a number after each of the E's, Word will
now sort them as numbers.

If you're using B as the letter, since Word doesn't seem to be able to parse
them as hexadecimal numbers (which they might be mistaken for in other
contexts), it goes ahead and sorts by the number in the 1st position.


--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Nelson" wrote in message
...
In a MS Word 2003, SP3, 6X1 table I place the following values one per row
4E
2E
3E
E
1E
5E

When I go to Table Sort "number" "ascending" the table will not
sort.
If I use Text instead of number it will. Now, If I change the letter E to
any other letter in the alphabet, using B as an example, the table will
sort
by number giving me the following result

B
1B
2B
3B
4B
5B

Any thought or ideas on this would be appreciated.

Thanks,
Nelson


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting a Table Nanapat Microsoft Word Help 4 April 18th 08 06:26 AM
Can you number a column in a database and keep it from sorting jeannette Tables 3 March 20th 06 07:05 PM
sorting text in a table Madame D Tables 1 November 7th 05 05:49 PM
Sorting mail merged labels by unique number Caledonia93514 Mailmerge 1 April 1st 05 08:23 AM
Table Sorting Melissa needing help!! Tables 3 February 15th 05 02:27 AM


All times are GMT +1. The time now is 03:23 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"