hi,
I have "inherited" a bunch of excel files which have been written with a
cell containing the TODAY() function, so when I open them they always change
the date. Is it possible to "freeze" this function so I can view the date
that the files were last modified instead?

Going forward, as I create more of these files I would like this cell to
display the date the file was created automatically and then not modify the
cell again.

Are either of these tasks possible?

Thanks for looking

Alan