Hi – I’m looking for some help with something I thought would be quick and easy but is proving not to be the case!

I’m trying to sort a data set of hierarchical numbers but am having issues with the 8.1 & 8.10 values (etc.), whereby the sort is treating them both as 8.1 – 

Copying the data from another piece of software into a table it looks like this –

After sorting (by smallest to largest) it treats both the same and returns –

I looked on line and found a post suggesting using a VBA function which treats the string as text to sort – 

Unfortunately this still returned the same value for the 8.1 & 8.10 items –

Any help would be greatly appreciated.

Thanks

​Hi – I’m looking for some help with something I thought would be quick and easy but is proving not to be the case! I’m trying to sort a data set of hierarchical numbers but am having issues with the 8.1 & 8.10 values (etc.), whereby the sort is treating them both as 8.1 –  Copying the data from another piece of software into a table it looks like this – After sorting (by smallest to largest) it treats both the same and returns – I looked on line and found a post suggesting using a VBA function which treats the string as text to sort –  Unfortunately this still returned the same value for the 8.1 & 8.10 items – Any help would be greatly appreciated. Thanks    Read More

​