List view numeric sorting (instead of alphabetic)

[WMEspo]

I have an auto-increment number field in my Accounts entity that is in the list view. When I sort the list ascending I get an "alphabetic" type sorting where 1s will always come before 2s, 3s, 4s, etc. For example if there is an account number that is 999 it will always be at the end of the list instead of one before 1000. The numbers end up getting sorted like 10, 100, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 200, 21, etc. I cannot figure out how to get it to sort numerically as opposed to alphabetically.

Is there a way to do that?

Thanks.

[yuri]

Hi,

If you had numbers padded with zeros (configurable) you wouldn't have such a problem.