I have a string field that needs to be sorted numerically instead of alpha-numeric. Only numbers will be entered into the field. Alpha-numeric shows this way:
1
10
11
2
23
37
8
I found a formula that works by creating a formula field with the following:
Right("0000" & {table.field},4)
However, I don't particularly like this solution as it results in this:
0001
0002
0008
0010
0011
0023
0037
I prefer to not have the zeros. Is there a way I can hide the zeros or is there another solution for sorting string fields numerically that would work better (and hopefully be just as simple)?

why not just use and sort on this?ToNumber({table.field})

your original formula would also fail on a non numeric value as it is also using the tonumber() function.

Edited by DBlank - 27 Oct 2014 at 8:19am