Hello and Happy new year,
if I create a custom list and I sort it alphabetically are there any "special" rules?

I have a list with the items:
1
2
...
...
9
10.1
10.2
11.1
11.2

now it sorts it like this:

1
10.1
10.2
11.1
11.2
2
...
...
9

Can I influence this by using a different separator like 10-1 ? I tried some but nothing really helped. Maybe I am missing something.

Best regards
waczny

    waczny

    No alphabetically means it starts with the first character and goes to the second, etc. just like words would be.

    Example:
    Azure
    Adam
    Boston
    Ashley

    … would then be …

    Adam
    Ashley
    Azure
    Boston

    Cheers.

      KevinTheJedi
      ok but why is it then that C10.1 is before C2? Or even C10 1 comes before C2?
      This is how it sorts it alphabetically:

      Should it not be A-Z > 0-9 > 10 -19 > etc?

        waczny

        Because C1 is before C2. It goes character by character. So even though it’s C10 in alphabetical order C1 comes before C2.

        Cheers.

          waczny

          Those look to be the same sort to me. OP0 comes before OP1, OP10 comes before OP11, etc.

          Cheers.

          Write a Reply...