How to sort column by numbers in Numbers?
I think by adding a word to each number you've forced it to sort strictly alphabetically, which does make 1, 1300, 16000 etc 'correct'. Removing the letters should revert to natural sorting.
Moving the words to a separate column should fix it. An easy way to split the numbers out for searching is to add a column between B and C and set =LEFT(B2, SEARCH(&quot; &quot;, B2) - 1) as a formula there.