User profile for user: tkyoung75
tkyoung75 Author
User level: Level 1
19 points

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
User profile for user: Badunit
Badunit
User level: Level 7
29,394 points

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.

View in context

Similar questions

2 replies
Sort By: 
Question marked as ⚠️ Top-ranking reply
User profile for user: Badunit
Badunit
User level: Level 7
29,394 points

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.

Reply

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 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.
Learn more Sign up