I cannot get the column to sort the dates correctly in Numbers! I want to sort the column by date and instead of sorting 1 through 12, it sorts like this: 1,10,11,12,2,3


Make sure you type in your dates in the format dd/mm/yyyy. For example 01/01/2019 02/01/2019 03/01/2019

The right-click the column at the top and click Sort Ascending.


Then your dates should be sorted in ascending order:


  • 1
    Or better in iso format 2018-12-25 – user151019 Jan 17 at 17:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .