Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Outline numbers
I need to sort a column of outline numbers (WBS structure numbers).
Like : 1.0 1.0.1 1.3.2.1 3.10.2.1 2.0.2 Excel treats some as text and some as numners. Is the a function that can do that? Can it be done without using a macro? 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) |