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.
|