My guess would be that your 2.1.0 and 6.6.1 are text entries, whereas the
other entries are numbers (such as 1.0 and 1.1) custom formatted the way you
describe. You can check by using the formulae =ISNUMBER(A1) and ISTEXT(A1),
copied down your colums as appropriate. The sort will put the numbers in
numerical order, then the text in alphanumeric order.
--
David Biddulph

"mjones" wrote in message
ups.com...
Hi All,

My spreadsheet has 9 columns where each row is an item. My items are
numbered in column A like this:

1.0.0
1.1.0
2.0.0
2.1.0
6.0.0
6.6.0
6.6.1

When I sort the data by column A, I get this incorrect sort:

1.0.0
1.1.0
2.0.0
6.0.0
6.6.0
2.1.0
6.6.1

The cells are formated as 0.0#.0#

I'm using the auto filter sort, but it comes out the same with a
regular sort.

I hope someone can help solve this problem.

Thanks,

Michele