I would like to sort a column in ascending or descending order by number of objects in Numbers. However, despite setting the 'data format' as 'number' it doesn't understand the right order.
This is the ascending order of the column in Numbers:
1 apple
1300 oranges
16000 peanuts
671 mangos
91 potatoes
When I want it to be in this order:
1 apple
91 potatoes
671 mangos
1300 oranges
16000 peanuts
Please, see screenshot: