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: