View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.