Link to home
Start Free TrialLog in
Avatar of lduning
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!!
Avatar of ghassan99
ghassan99

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
Avatar of ghassan99
ghassan99

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lduning

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.