# Arrange numbers natural not lexicographical **URL:** \ **Category:** Get Answers\ **Created:** [March 10, 2019, 8:25pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792 "2019-03-10T20:25:38Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![NOURFAYEK03119](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/nourfayek03119/32/231_2.png) [@NOURFAYEK03119](https://forums.knack.com/u/NOURFAYEK03119)\ **Post date:** [March 10, 2019, 8:25pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/1 "2019-03-10T20:25:38Z")
Anyone knows how to sort records on the live app in the normal order ? (1,2,3,4,5,) instead of this annoying (1,11,12,2,21,3,31,32) Please do not tell me to put a leading zero as I have over 2000 records I cannot put 0001 0002 0003... There has to be another way. ---
**Author:** ![BradStevens](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/bradstevens/32/140_2.png) [@BradStevens](https://forums.knack.com/u/BradStevens)\ **Post date:** [March 13, 2019, 10:06am UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/2 "2019-03-13T10:06:28Z")
Hi Nour - I might be missing something but my tables sort correctly. Clicking any of these columns sorts properly, and the only thing I can think of is that these are all number types (not text fields)? ![](https://support.knack.com/hc/user_images/9SRQch7j02SMnr_NR4Ja5A.png) ---
**Author:** ![TimLohnes65432](https://avatars.discourse-cdn.com/v4/letter/t/ecb155/32.png) [@TimLohnes65432](https://forums.knack.com/u/TimLohnes65432)\ **Post date:** [March 11, 2019, 8:56pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/3 "2019-03-11T20:56:03Z")
I don't know about your original question, but a workaround could be adding the zeros, then adding a new calculated field that strips the zeros and use that field to show your information. Actually, that probably would leave you back where you started. Scratch that, I think. Also, what kind of field are your numbers? When I add an auto-incrementing number field, then click the heading on the page to sort, it looks fine. ![](https://support.knack.com/hc/user_images/kB4NIMB-7EHfE4lYne416w.png) ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 28, 2024, 9:27pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/4 "2024-06-28T21:27:41Z")
You ever get a solution? I cannot believe Knack does not have a way to sort numbers! ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 28, 2024, 9:43pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/5 "2024-06-28T21:43:02Z")
Hi @JerrellWil97366 The issue here is the difference between text and numbers. If the number is in a text field it will sort them 1 11 12. You can use conditional rules and equations to fix this Craig ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 28, 2024, 10:10pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/6 "2024-06-28T22:10:06Z")
Great. How? ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 28, 2024, 10:22pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/7 "2024-06-28T22:22:48Z")
Well that depends on the data you are storing in the field. Is it just numbers or numbers and text? Do you have an example of the data you are storing in the field? ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 29, 2024, 12:03am UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/8 "2024-06-29T00:03:01Z")
It’s just numbers. It’s a number field. Only numbers. ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 29, 2024, 1:46am UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/9 "2024-06-29T01:46:36Z")
I appreciate the response. Would love to get resolution. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 29, 2024, 8:44am UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/10 "2024-06-29T08:44:37Z")
If that’s the case it should order by number. It only sorts the other way if it’s a text formula or text field. I would get in touch with Knack support. I’ve never seen a number field sorted that way. Sorry if I misunderstood. Craig ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 29, 2024, 12:08pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/11 "2024-06-29T12:08:01Z")
Actually, it doesn’t work that way. In a live app grid, knack sorts numbers as text. It’s very frustrating. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 29, 2024, 6:14pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/12 "2024-06-29T18:14:55Z")
I’ve never had that issue. If it’s a number field it will always sort correctly. The only time it doesn’t is if it’s a text field. As I said you should contact support for this. When I am back at computer I’ll demonstrate with some screenshots. Craig ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 29, 2024, 7:39pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/13 "2024-06-29T19:39:15Z")
Thanks. I look forward to the screenshot. And to be clear, I’m talking about sorting a grid in a live app (according to a number field), not a table in the builder. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 29, 2024, 9:30pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/14 "2024-06-29T21:30:59Z")
Yes ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 29, 2024, 9:46pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/15 "2024-06-29T21:46:35Z")
Hi So this is a number field with a custom suffix sorted: ![Screenshot_2024-06-29-22-39-14-003-edit_com.android.chrome](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/7f8ac3f3b6a079bbc52583cf7071790af93793cf.jpeg) This is a text formula field that equals a number field + w sorted: ![Screenshot_2024-06-29-22-39-42-768-edit_com.android.chrome](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/400642ba58205b26a1a4b9bdb494710ca09b9cdd.jpeg) ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 29, 2024, 11:47pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/16 "2024-06-29T23:47:11Z")
That’s an example of sorting a table in the builder. Try the same thing with a grid in a live app. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 30, 2024, 12:52am UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/17 "2024-06-30T00:52:07Z")
That is my live app. ---
**Author:** ![JerrellWil97366](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@JerrellWil97366](https://forums.knack.com/u/JerrellWil97366)\ **Post date:** [June 30, 2024, 12:24pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/18 "2024-06-30T12:24:52Z")
I see my problem. I grouped the grid on the number field. Apparently, grouping prevents sorting on the number field. Also, I really don’t want the use to have to force the sorting. I’d rather it sort for the user. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 30, 2024, 12:41pm UTC](https://forums.knack.com/t/arrange-numbers-natural-not-lexicographical/6792/19 "2024-06-30T12:41:54Z")
Hi number fields sort correctly when grouped: ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/43554fff55092bc22d5127fddf17548feb699951.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/6/6c150a497f494366848b7fe6e4ae83647ebecdfa.png)