sorting people results

[Priscilla Bueno]

I am trying to sort by number, que columns called "identificação" - but instead os going from 1,2, 3 and so on - it goes from 1 to 10 to 100, to 1000 , 1001...
Can anyone tell me what I am doing wrong?

[Gregg]

Reunion is doing an alphabetical sort not a numeric sort.

You would need to add leading '0's to get this list to sort numerically. For example change "Site 1 ok" to "Site 0001 ok" and "Site 102 ok" to "Site 0102 ok"

I realize this is probably not an reasonable option, that is just the nature of an alphabetical sort.

[ttl]

It's counterintuitive, but that's a text column that's being sorted alphabetically. As an example, "Site 101 ok" comes after "Site 1009 ok" because when sorting by text, "101[space]" comes after "1009". It's like "bab" would come after "baai".

Edit: What Gregg said.