Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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: