Sorting Numbers with established numerical hiearchy
 

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.

Sorting Numbers with established numerical hiearchy
 

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

--
Gary''s Student - gsnu200751


"Smedlynf" wrote:

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.