Number Sequence 1, 10, 2, 3, 4, 5, ... instead of 1, 2, 3, 4, 5, ... 10, 11, ....

[irfan_abdrhman]

Hi Community, I want my numbering sequence to be 1, 2, 3... instead of 1, 10, 2, 3.. how to address this issue simplest way possible or the many alternatives? Thank you

[aduguid]

You could create calculated columns like the following:

Supplier Sort = VALUE(SUBSTITUTE([SUPPLIER_NAME], "SUPPLIER ", "")  )

[lbendlin]

If you want to sort your text column differently you need to introduce a sort column.  Read about "Sort one column by another column".