Changing Dates in Excel

J

Jackie

When I open a file, the dates keep changing to the current date. How do I
stop this?
 
B

Bob Phillips

It must be a formula (=TODAY()).

You need to input the dates (Ctrl-:), or use VBA to set them.

What does the spreadsheet do?
 
J

Jackie

When I open a file with a previous date it changes it to the current date. I
need to know how to turn it off so I can keep the previous date?
 
Top