View Single Post
  #2   Report Post  
Kirchberger
 
Posts: n/a
Default

From Excel Help -

Insert the current date and time in a cell
Insert a static date or time

Current date Select a cell and press CTRL+;
Current time Select a cell and press CTRL+SHIFT+;

Current date and time Select a cell and press CTRL+; then SPACE then
CTRL+SHIFT+;

Gary