lduning
asked on
Excel Sorting
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!!
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!!
It will work normally in Word!! just put each outline in a separate row then select the whole column and click sort!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sounds like my suggestion of moving the data to Word is the best option. Thanks.
no not necessarily...coz excel assumes integers or numbers for its cells....when u enter one point it will assume its an integer while Word wont do that...the only difference is being forced to add an extra deciaml point in Excel so it wont be mistaken with a number or an integer.