Hi
I have been helped with a brilliant UDF formula which will pad numbers e.g. 1 becomes 001
Currently I have a hierarchy which is impossible to sort correctly e.g. in its current view 1.11 appears before 1.6 which I want to avoid.
I have been playing around with the data and I think that if I am able to apply the padnum formula to column A then somehow then this would work (I hope). E.g. In the example above this would become 001.011 and 001.006 which would mean sort would work.
In the attached example in column E I have the desired result – is there any way to achieve this with formula? Please note there is no consistency on the number of dots, it ranges from 1 to 10.
Can anyone help please?
Bookmarks