View Single Post
  #4   Report Post  
Cene K
 
Posts: n/a
Default how do I insert the current time (static) and date in a cell?

Ctrl + ; will return the date Ctrl + Shift + ; will return the time

"DF" wrote:

That instruction does not help; I have tried to do that, but nothing happens.

"Peo Sjoblom" wrote:

Ctrl + ; and Ctrl + :


--

Regards,

Peo Sjoblom

"DF" wrote in message
...
I want to use Excel as an automated timesheet.