| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Numerically
Pleas help. I have a spreadsheet that was e-mailed to me and it is not
sorting the data properly. I am trying to sort by decending order and this is what happens: 828 827 824 8,903 8,581 -8 791 786 773 758 75 746 738 732 726 719 7,964 How can I get it to sort with 8,903 being the first value and -8 being the last?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting Numerically
Pl see response in your later post
(convert text numbers to real numbers) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ps.com... Pleas help. I have a spreadsheet that was e-mailed to me and it is not sorting the data properly. I am trying to sort by decending order and this is what happens: 828 827 824 8,903 8,581 -8 791 786 773 758 75 746 738 732 726 719 7,964 How can I get it to sort with 8,903 being the first value and -8 being the last?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
| Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
| Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
Hybrid Mode
