| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting numbers as text
I hadn't had a chance to thank you all for the good suggestions.
Thanks wrote: Take this helper column: =INT(--A1)*10+LEN(A1)-FIND(".",A1)--A1-INT(--A1) Copy down. Sort by this. Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting numbers and numbers that contain text in excel | Excel Discussion (Misc queries) | |||
| sorting text with numbers | Excel Worksheet Functions | |||
| Help sorting text as numbers | Excel Worksheet Functions | |||
| Sorting numbers as Text | New Users to Excel | |||
| SORTING TEXT AND NUMBERS | Excel Worksheet Functions | |||
Threaded Mode
