Software

Ask something
Discussion Locked

Disable "Auto Date"

0 helpful
5 replies

by megtek

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I stop Word and Excel from automatically updating the date to the current date whenever people open existing documents?

5 replies

by liame

A date derived from a formula (eg =today()-20)will change whenever the sheet is opened. To get these to stop calculating and use the displayed value from now on select the offending cells and copy them, then select paste special and select the paste formulas as values option.

Sorted.

by ichu50

Right click on the date and select Toggle field codes.
Change the function TIME to DATE.

This discussion is closed to new replies.