static date
 

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

static date
 

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/

static date
 

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

On Mon, 2 Jul 2007 07:04:38 -0400, Stan Brown
wrote:

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