| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sorting numbers more than one decimal
I have pasted an example of the numbers below. Why does the sorting start
over at the bottom of the list? I want the last number on the list 87200.028.1 to appear after the fourth number 87200.028 and then 87200.029 would be after 87200.028.1 I realize that this is directly related to the faxt that the first numbers have one decimal and the ones at the bottom of the list have two decimals. What can I do about it? 87200.022 87200.023 87200.027 87200.028 87200.029 87200.031 87200.031 87200.032 87200.032 87200.033 87200.034 87200.035 87200.035 87200.036 87200.037 85600.403.1 86100.708.1 86500.403.2 87200.028.1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Threaded Mode
