View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Date/time groupe

=now()

in the cell, then hit F9 to update. It will actually update each time the
sheet is calculated.

--
Regards,
Tom Ogilvy

"Johan H. Olsen" wrote in message
...
Hi! I am trying to make a communicationlogg with a field that is
supposed to be auto updated with date and time in the same cell. The
time is supposed to be auto updated from the PC clock and the whole
cell should be filled out just with hitting the return button.
Is this possible?
(Sorry for bad English.)



Johan