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.
Example
