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
|