static date

[Guest]

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

 

[Stan Brown]

Mon, 2 Jul 2007 03:52:08 -0700 from Alan g1bdu

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?

As with any formula:

Click in the cell, or click and drag to highlight the range.

Edit | Copy

Edit | Paste Special and select "Values" only

 

[Gord Dibben]

Be aware that these dates that have been set to values will not change when the
workbook is "modified".

If you want that, you would need some type of event code to update the dates
when the workbook was last modified but not change is no changes are made.


Gord Dibben MS Excel MVP