Sorting Numbers with established numerical hiearchy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to go into excel and sort my numbers descending but I want the normal
counting integrity to be maintained. If these are my numbers
:
101
1054
134
169
1855

When I go to sort them they will fall into this order. I would like them to
sort like this:

101
134
169
1054
1855

Please let me know if you can help.
 
If the numbers do not sort in numerical order, they are probably text rather
than "real" numbers. I suggest you first convert them to "real" numbers and
then sort.

Place a 1 in an un-used cell and copy it. Select the cells you want to
convert and:
Edit > PasteSpecial > multiply.

Then do the sort
 
Back
Top