=now()
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+;
--
paul
remove nospam for email addy!
"Jim" wrote:
Hello,
How do (is there a way) to write = NOW( ) so that the date will become
static once the Excel sheet is opened?
|