It can be done using circular reference or code

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



--
Regards,

Peo Sjoblom

(No private emails please)


"Anthony" wrote in message
...
when the user inputs data into cell C8 I want the current time to be
displayed in cell D8, and remain there without changing value, so if the
user
inputs the number1 into cell C8 the time 17:00 is shown in cell D8, and
from
that moment on it does not change.

Can this be done, if so any ideas??

Thanks