Sorting Data
I am using an Excel 2003 worksheet for Bill Of Materials. I also you the
Worksheet in AutoCAD for Item callouts.
So my dilema is that I use a numbering convention of :
1.1
1.2
1.3
..
..
1.9
1.10
1.11
1.2
1.3
When I sort these numbers they come back sorted numerically
1.0
1.10
1.11
1.2
1.3
Is there anyway in Excel to sort these with out cutting and pasting the
items in place.
|