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

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/