I would suggest some type of event code that adds a static timestamp rather
than have a formula-derived one.

But you can prevent a formula from updating using worksheet functions alone.

Couple of methods on John McGimpsey's site

One without VBA and one with.

http://www.mcgimpsey.com/excel/timestamp.html


Gord Dibben MS Excel MVP


On Sun, 17 May 2009 07:01:12 -0700, james
wrote:

excell spreadsheet, cell acquires date from formula, but when new information
is entered the date changes, I need it not to change once the formula has
been made.