As an alternative, you may want to look at how JE McGimpsey does it based on a
cell changing:
http://www.mcgimpsey.com/excel/timestamp.html

Marc G wrote:

I've set up a spreadsheet to enter the current time and date in particular
cells when data is entered into another cell (basically i'm using a formula
to record the time data was entered into each cell).

I've used the following formula to do so, =IF(C20,NOW( )),
Problem is the cell just updates when the file is saved as the formula gets
recalculated.

I believe i need to find a way of allowing induvidual cells to calculate
only once to prevent this from happening.

Anyone have any ideas? or know of another way to accomplish this task?

--

Dave Peterson