Sorting Data

[Guest]

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.

 

[Guest]

Hi,
One solution - insert a "sort" column to the left or right of your numbers
column. Number those cells from 1 to whatever and use it to sort. You can
hide the column if you don't want it showing.

 

[Guest]

hi,
I usually handle oddball sorts like that with a helper column then use that
as my first sort but i am not sure how much extra work for you this might be.

example>
1.1 = 1
1.2 = 2
1.3 = 3

1.9 = 9
1.10 = 10
then sort by the helper column,

regards
FSt1