Ascending ordering using numbers

Anmeldedatum: 11.03.2022 Beiträge: 2

Hello.
I tried to use (what I considered toe be) a numerical field to sort contacts but instead of obtaining something like:
1 Contact1
2 Contact2
3 Contact3
...
I end up with:
1 Contact1
10 Contact10
100 Contact100
101 Contact101
...
I used field Postcode but it seems all Address section details are consolidated and treated as text hence the above sorting.
Is there a workaround for this?
Thank you

Moderator Anmeldedatum: 19.04.2014 Beiträge: 15906

This should work with leading zeros
001 Contact1
002 Contact2
003 Contact3
...
010 Contact10
...
100 Contact100

Informationen zum Datenschutz auf dieser Website