How to arrange number sequentially

Question

Hi everyone,

I just need help in one of my field...ive already input the numbers in my field but they are not coming serially even though i put them in ascending order instead of showing 1..2..3 etc the numbering shows as 1..100..102..2 etc can u help me so that the numbers come in ascending order..i hope u get my point..thank you

JoeBorgione · Answer

What did you try that didn't work?

alexandernongkhlaw · Answer

itried not working

danretired · Answer

It is called a "natural sort"

Migration from ArcMap to ArcGIS Pro for data validation—ArcGIS Pro | Documentation provides some coding options.

In the future if you want to use "text" numbers, you can pre-pend 0's

0001

0011

0111

1111

If you don't want them be in text format, which they currently are, you will have to add a new integer field (short or long) and recalculate the values into it using

int(!YourFieldName!)

then use that field for sorting.