Lookup integer sorting order



I was wondering if there is a way or perhaps if its under development: a way to order lookups of short text fields and number fields the same. As it currently exists it seems that it lists each item from left to right in a text look up, but from right to left in a numerical lookup. See attached image for example.

Any insights are greatly appreciated!


I’ve actually found that it’s even worse than just numerical vs. text. It’s that the linked field and lookup field list in opposite order–that is, if you manually move the records in the linked field, the records in the lookup field changes to mirror that order. I’m not sure why this is and would love either a workaround or a feature fix!