Numbers won't sort DATES correctly

Question

Level 1

15 points

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

Answer 1

Best reply

Sheppad

Level 1

139 points

Jan 17, 2019 2:17 PM in response to Hansfords

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.

Reply

Answer 2

Hansfords Author

Level 1

15 points

Jan 17, 2019 2:25 PM in response to Sheppad

I got it to work - I tried so many times that I can't remember how I finally achieved it! But under the FORMAT tab I selected Date/Time and then below selected that I selected 1/15/19 and under that I selected None for the time. Thanks for your reply!

Reply