Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting numbers with decimal points
I am trying to sort numbers like this in one cell:
..875 x 1.655 x 96.75 ..500 x 1.800 x 97 ..875 x 1.655 x 108.75 I can get the first 2 sets of numbers to sort but the last one sorts the 108.75 before the 96.75. That number is higher, how do I get to it to sort that last? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting numbers with decimal points
It won't. You've got text in the cell, not numbers, so a 1 will sort before
a 9. The easiest way may be to use Data/ Text to Columns to separate the elements of the cell into 3 different columns, then select the 3 columns and sort (then concatenate them back if you need to, but you're better off keeping the elements separate if you can). -- David Biddulph "Trish" wrote in message ... I am trying to sort numbers like this in one cell: .875 x 1.655 x 96.75 .500 x 1.800 x 97 .875 x 1.655 x 108.75 I can get the first 2 sets of numbers to sort but the last one sorts the 108.75 before the 96.75. That number is higher, how do I get to it to sort that last? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
Decimal Points | Excel Worksheet Functions | |||
Decimal points not needed | Excel Worksheet Functions | |||
sorting numbers more than one decimal | Excel Worksheet Functions |