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