Is there a way to sort a column that contains "numbers" with more than one decimal? I'm trying to sort numbers from an outline such as:
1.0 1.12 1.12.1 2.12 2.1.13
It seems that Excel recognizes numbersd as one decimal and doesn't have the ability to sort numbers from an outline format. Is that correct?
I have moved the data into Microsoft Word and am trying to sort that data in a table. It seems to be getting closer to the correct results.
Thanks for any suggestions!!