Changing Dates in Excel

[Jackie]

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

 

[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?

 

[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?

 

[Bob Phillips]

I think that was what I answered.