Hi
From Excel Help (Keyboard shortcuts)
CTRL+; (semicolon) Enter the date
CTRL+SHIFT+: (colon) Enter the time
Arvi Laanemets
".:mmac:." <lost@sea wrote in message
...
How can I set a cell to contain the =NOW() date only once when data is
entered in the adjacent cells and not have it update after that?
Right now I copy from a cell that contains =now() and paste value only
into
the cell. Is there an cleaner way?
|