You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers Dates and Times

Would you please fix the numbers sort function so that it sorts dates and times properly

MacBook Air 13″, macOS 12.6

Posted on Jan 12, 2023 5:32 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 12, 2023 7:02 PM

The sort feature works fine. It is most likely your data or a misunderstanding about date format or about display vs the actual value in the cell. Each of your dates has a year, even if it is not displayed in the cell. Try displaying the full date, including the year, for that column and see if it sorted correctly.

2 replies
Question marked as Top-ranking reply

Jan 12, 2023 7:02 PM in response to tkyoung75

The sort feature works fine. It is most likely your data or a misunderstanding about date format or about display vs the actual value in the cell. Each of your dates has a year, even if it is not displayed in the cell. Try displaying the full date, including the year, for that column and see if it sorted correctly.

Numbers Dates and Times

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