Sorting numbers

  • Thread starter Thread starter Douglas Sey
  • Start date Start date
D

Douglas Sey

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
 
Douglas,

I think Excel is seeing your 'numbers' as text and so is sorting them one
character at a time from the left regardless of how many characters,
(numbers) you have. Try changing the text numbers to real numbers by
copying a blank cell, highlighting the range of numbers and then right-click
and select Paste Special > Add. To avoid sorting the header simply
highlight the only the data that you want to sort.

HTH

Sandy
 
Back
Top