"Peggy" wrote in message
...
: Time() returns the current time but upon every keystroke or recalculation
it
: updates. I would like a non-updating time stamp every time I enter a
number
: into an adjacent cell.
:
Try something like this.
Place this formula in the cell you want the time stamp in

=IF(ISBLANK(A1),"",TimeStamp())

replace A1 with the cell you want to use to change the stamp
then create a code module with this function

Public Function TimeStamp()
TimeStamp = Time()
End Function

Paul D