Numbers Date Format Without Time?

Is there a some date format that does not show the time when editing?

User uploaded file

iMac, OS X El Capitan (10.11)

Posted on Oct 17, 2015 9:48 AM

Reply
3 replies

Oct 17, 2015 3:51 PM in response to Bruce Kieffer

You can enter "just the date" in cells with a Data Format set to Text. The easiest way to do that is type a ' (an apostrophe) before you enter a "date".


Here, I've entered the "date" as text in A3. Note it is left-aligned by default unlike a date-time string, which is right aligned.


Though it is text and you can edit it as such (i.e. you won't see a time component of a date-time string), the date functions still work.


User uploaded file



SG

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 Date Format Without Time?

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