Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting numerical data | Excel Discussion (Misc queries) | |||
Excel Validation List Hiearchy- How to???? | Excel Worksheet Functions | |||
sorting data using numerical list | Excel Worksheet Functions | |||
Sorting Numerical Values... | Excel Worksheet Functions | |||
replicating a folder hiearchy. | New Users to Excel |