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

Level 1

8 points

date/time format problem

I need to add a date into the spreadsheet data table and I have tried to update the cell format to Date/Time but it wont save it?

Any suggestions?

Many thanks

Posted on Jan 9, 2022 2:01 PM

Reply

Top-ranking reply

Level 7

28,810 points

Posted on Jan 9, 2022 3:27 PM

2017 was not a leap year. There was no Feb 29

View in context

Similar questions

Unable to insert date and time I have formatted the cell for date [dd-mmm-yyyy] and time [H:MM XM]. Inserting date and time from menu command enters date only, in [MMM YY] format, changing my cell format to date only consistent with format displayed. Changing format to desired does change the date to format desired, however inserts 12:00 PM which seemingly can’t be updated except laboriously by hand. Any suggestions?
515 4
Entering times (without a date stamp) Hello, I enter a time 02:32 col B and then in column C Im entering another time 14:34. I am getting the time difference in col D. My format is the there is no date just time. Yet if I enter these times there is always a Date attached to the time. Is there any way that I can get rid of the Date stamp? Thank you
477 5
How do I create a column in Numbers which displays date and time increasing? How do I create a column in numbers which displays date and time increasing by 30 min intervals? Cannot see anything in Numbers Help to achieve this. [Re-Titled by Moderator]
420 6

3 replies

Top-ranking reply

Level 7

28,810 points

Jan 9, 2022 3:27 PM in response to fotonut

2017 was not a leap year. There was no Feb 29

Reply

Level 9

59,957 points

Jan 9, 2022 3:40 PM in response to Badunit

"Jan 9, 2022 3:27 PM in response to fotonut

2017 was not a leap year. There was no Feb 29"

Good eye!

Reply

Level 1

8 points

Jan 9, 2022 3:32 PM in response to fotonut

Thank you, I was working on someone else's data and assumed it was correct. I will move the data to the 1 march thanks!

Reply

date/time format problem

Welcome to Apple Support Community

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

Learn more Sign up