what do the numbers look like when you format them as general.
check if you entered the 2.1.0 as 2.1. and the 6.6.1 as 6.6.1

the entry format needs to be 2.1 and 6.61

"mjones" wrote:

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