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

How do I keep Numbers from inserting today's date in custom format cells

I have a custom format that consists of hour:minute:second. No date, just time.


When I enter a time (e.g., 07:21:30) Numbers silently adds today's date to the cell, and uses that date for sorting.


So if I add a row with a cell value 07:21:30 today, and tomorrow add a row with a cell value of 07:18:00 tomorrow, Numbers will sort the earlier time after the later time because of the hidden day values in the cells.


How do I make it stop doing this?


iMac (24-inch, M1, 2021, 2 ports)

Posted on Aug 29, 2022 11:07 AM

Reply
Question marked as Best reply

Posted on Aug 29, 2022 12:38 PM

Have you already applied this cell formatting to suppress the date content?



There is a dedicated Numbers for Mac support community for these type of product specific questions, and would likely get you faster response.

Similar questions

2 replies

How do I keep Numbers from inserting today's date in custom format cells

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