Hi
Please advise, if the time will be saved.
Because NOW(), gives thecurrent time.
Example, If I had entered data in cell A1 yeterday and today when I go in
the sheet. Will I see the time in cell a2 that of yesterday or the current
time.


"dlw" wrote:

=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