Name Items with Numerals

Finance Active applications enable you to sort lists by alphabetical order. However, it happens this criteria does not always suit your needs. A popular solution is using numerals, to order items with numeral order: 1, 2, 3, etc.

Yet, this method does not display the order you expected either. For example, most items are ordered alphabetically: 2, 3, 4, etc. But #10 displays before #1 and #20 displays before #2.


When naming numerals, we may only focus on the numeral order itself, i.e. 1, 2, [...], 10, 11, while the computer considers the numerals as characters, i.e. all numerals starting with "1" will be listed first, followed by numerals starting with "2," etc.

To fix the list, add 0 before the numerals 1-9, i.e. 1, 2, 3, etc., now become 01, 02, 03, etc.


Remain consistent: all numerals must include the same number of digits. In the previous example, we only added one 0, as the other numerals, 10 and 20, only include two characters.




Was this article helpful?
0 out of 0 found this helpful