Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address

The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.

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

ElViejo1939 Author

Level 1

18 points

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

Best reply

VikingOSX

Community+ 2024

Level 10

112,475 points

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.

View in context

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

Similar questions