Numbers won't sort DATES correctly

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,etc.


On the drop down menu under the Format tab, I select "Sort by: Date" but then the next drop-down only gives you the option of Ascending (1,2,3...) or Descending (3,2,1...) but it doesn't recognize the difference between a 1 and a 10 in front of the / (forward slash)

MacBook Air (2018 or later)

Posted on Jan 17, 2019 8:09 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 17, 2019 2:17 PM

Is there an apostrophe ' in front of the date?


When my dates misbehave, I highlight the whole column and then format it as automatic, or as Date/Time and then select the specific format you like, such as 01/07/2019 or 07/01/2019, etc.

4 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers won't sort DATES correctly

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.