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.

--
Ken Hudson


"SchnidRoCK" wrote:

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.