| Registered: May 5, 2013 | | Posts: 11 |
| | Posted: June 16, 2013 12:01 PM | | | | If I "Sort by Location", numbers below 100 are located as if they had an imaginary 0 at the end. eg.
instead of sorting like this:
98
99
100
980
990
it sorts like this:
100
980
98
990
99
I know I can go back and add leading zeros to the first 99 locations, but I shouldn't have to.
Why sort by Location in the first place? To find typos, for one example. |
|
| Registered: March 21, 2007 |  Posts: 163 |
| | Posted: June 16, 2013 12:12 PM | | | | Location is an alphnumeric field. The way it sorts at present is correct. If you want to use only numbers then you must include leading zeros. |
|