Why the sorting of my numbers is wrong?

Question:

Why the sorting of my numbers is wrong?

 

Answer:

This is typically due to the fact that Text is chosen as the data type of your number field. Perhaps you imported the data through a CSV file. All CSV fields are treated as text.

To fix this issue, open your table in Design, and change the data type of the field to Number. Then save the table design.