MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Prevent Change Of Date If Its Set for Today When the Day Changes?

I have formatted the column for date to today.
Now when the day changes, the date also changes to the next day in all the cells that I had filled for the previous day
Is there a way to prevent this ?
—–
Vikram kumar

Comments: One Response to “How Do I Prevent Change Of Date If Its Set for Today When the Day Changes?”

    2 months ago

    You need to not use function for the date. Instead, type the date. The function (are you using NOW?) will update.
    You can always use the menu item Insert, Date & Time instead of typing — it will enter the date as text, not using NOW. You can set a keyboard shortcut for that if you want speed.

Leave a New Comment Related to "How Do I Prevent Change Of Date If Its Set for Today When the Day Changes?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)