Get current time NOW() but stop it updating
Ctrl and the ; (semi colon) hit simultaneously will return the current date
to a cell and it will not be updated.
Please hit Yes if my comments have helped.
Thanks!
"goneil" wrote:
I want to time stamp a cell automatically with the current time (ie) without
the data entry operator having to do anything, however I don't want it to
update all the time I want it to just remain as is permenantly. I cannot
make NOW() stay the same.
Cheers
|