Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Douglas Sey
 
Posts: n/a
Default Sorting numbers

I am having difficulty when attempting to do a numbers descending sort, from
a position where the data is in rows.
I have no trouble with other sorts of this type, but in this particular
sort, a six digit number is sorted behind a five digit number, because the
first digit is smaller than the first digit of the five figure number.
Any help please?
- Also how do I avoid getting the title headings (shown in the left column,
in the row alignment) unnecessarily involved in the sort?

Thanks in advance
douglas


Reply
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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Sorting hyphenated numbers Connie Martin Excel Discussion (Misc queries) 5 February 20th 09 01:57 PM
Sorting when some numbers have a text suffix confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 11:19 PM
Sorting imported "numbers" Confused on the tundra Excel Discussion (Misc queries) 5 December 17th 04 08:33 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM


All times are GMT +1. The time now is 11:47 AM.

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

About Us

"It's about Microsoft Excel"