View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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