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

"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.