Hello Forum,

When I sort the data in a numbered cell from lowest to highest, I run into a problem. Numbers 2012-1 through 2012-10 are fine. However, the next number after 2012-10 is 2012-100 instead of 2012-11. Number 2012-11 does now show up until after number 2012-109. The next number following is number 2012-110.

Example:

2012-1
2012-2
2012-3
2012-4
2012-5
2012-6
2012-7
2012-8
2012-9
2012-10
2012-100
2012-101
The numbers are not stored as text.

How can I get the numbers to sort from 1 to 500 sequentially?