Apple Numbers: How can I sort numbers alphabetically rather than lexicographically
When I use Organize > Sort > Column A > Ascending (1, 2, 3....) it sorts like this:
Fruits 1
Fruits 10
Fruits 11
Fruits 12
Fruits 2
Fruits 3
Fruits 4
Fruits 5
Fruits 6
Fruits 7
Fruits 8
Fruits 9
I believe this is lexicographic sorting. How can I sort it alphabetically so my list is like this:
Fruits 1
Fruits 2
Fruits 3
Fruits 4
Fruits 5
Fruits 6
Fruits 7
Fruits 8
Fruits 9
Fruits 10
Fruits 11
Fruits 12
There doesn't seem to be any other options other than sort Ascending and sort Descending
I know I can prefix with the single digit numbers with a zero to make them sort how I wish, but it's annoying to have to do that all the time. Is there a better way?
Environment:
Numbers version 13.1 (7037.0.101)
Mac OS 12.7.1
MacBook Pro 15″, macOS 12.5