If you force all cells to be text format, you should be able to get your
sort.
From the Format | Cells menu select Text on the number tab.
--
Paul Cordts


"SpaceCamel" wrote:

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,