I'm sure there's an easy fix for this one, but I don't see any previous posts
about it, so here goes...

I have a long (about 500 lines) list of numbers that are sorting 10s, 11s,
etc. with 1s. How do I get the higher numbers lower down the list?

Here's what I mean. The following are sorting like this when I use auto
filter:

1.1.1.2.1.2
1.1.1.2.2.11.8
1.1.1.2.2.6.9
1.1.1.2.3.4
1.10.1.2.1.1
1.10.2.3.2
1.12.2.2.3
1.14.5.2.6
1.2.1.6.4.1
1.2.1.7.2.4.1

when they should sort like this:
1.1.1.2.1.2
1.1.1.2.2.6.9
1.1.1.2.2.11.8
1.1.1.2.3.4
1.2.1.6.4.1
1.2.1.7.2.4.1
1.10.1.2.1.1
1.10.2.3.2
1.12.2.2.3
1.14.5.2.6

thanks!