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.

Sorting Data
 

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.

Sorting Data
 

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.