That would need VBA. You'll see suggestions in the archives of this
newsgroup.
--
David Biddulph

"ub" wrote in message
...
Thanks a lot, It works
Please advise if I can use to automaticaly enter time in my sheet.
Example, if user has entered a value in cell a1, the current time should
stamp autmatically in cell a2 and the time value should be saved.

Thanks

"David Biddulph" wrote:

Control semi-colon, space, Control-shift-colon
--
David Biddulph

"ub" wrote in message
...
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