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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Prevent Change Of Date If Its Set for Today When the Day Changes?
Comments: One Response to “How Do I Prevent Change Of Date If Its Set for Today When the Day Changes?”
Comments Closed.
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.