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
2 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.

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 Account.