NOW() but stop recalculating!

[schroeter]

ok, i can get the NOW() funtion to paste the date when the cell was las
updated, but as soon as the next cell (date) is updated, the origina
date is updated also.

I need to figure out how to get the date to stop calculating each tim
the worksheet re-calculates.

help!

schroete

 

[JE McGimpsey]

Take a look here for a way to timestamp a cell:

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