Get current time NOW() but stop it updating
Yes, but this solution doesn't meet the OP's requirement "without the data
entry operator having to do anything"!
Stefi
€˛trip_to_tokyo€¯ ezt Ć*rta:
Ctrl plus the shift key plus the ; (semi-colon) (hit all 3 keys at the same
time) will return the current time in the 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
|