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.