Date

In a Date column: Is there a way to enter just the day for example: 5 and getting the following: 05/06/07?
Thanks.

Posted on Aug 23, 2007 10:42 AM

Reply
18 replies

Sep 6, 2007 10:24 AM in response to John H

So I called Apple Care today and got right on. The tech had the same problem but found a work around. Double click in the cell, Insert - Date & Time, immediately before leaving the cell right click (control click) on the actual date it has inserted and choose Edit Date & Time..., then choose a format including a time. The time inserts in there correctly. The secret is to edit to show a time before you leave the cell.

I know it is a lot of work as a workaround. The tech acknowledged the bug and said he would escalated it and I also submitted a bug on it. Hope this helps.

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.

Date

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