I dont want a different time , when I tab to another cell or reopen the sheet.
Is there any way I can store the value of now() in any cell.

"David Biddulph" wrote:

.... but next time you open the sheet, NOW() will be a different time. Did
the OP want that?
--
David Biddulph

"dlw" wrote in message
...
=IF(A10,NOW(),0)
that will put the current time if a value of 0 is entered
it will be a funny number, if you format the cell Time it will be a time


"ub" wrote:

Hi

What I want to do is that if I enter a value in a cell (Ex A1), in cell
A2,
I want the current system time to automatically stamp and save it.
Please advise if this is possible.

Thanks