| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Outline numbers
Using Text to Columns, with the "." as the separator will work, but that requires several columns. If you are desperate<g, my commercial add-in "Special Sort" will do it. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "SpaceCamel" wrote in message When I try the substitution on this list the sort still is not correct. 3.10 3_10 3.11 3_11 3.6 3_6 3.7 3_7 10 comes before 6, etc. I got a VBA funtion to work but was hoping for a technique that didn't require the addition of another column. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort numbers | Excel Discussion (Misc queries) | |||
| Sort "text" numbers with and without leading zeros as numbers | Excel Discussion (Misc queries) | |||
| sort an outline without changing the hierarchy | Excel Discussion (Misc queries) | |||
| Sort by last two numbers | Excel Discussion (Misc queries) | |||
| Help Sorting Outline Numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
