View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default 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