To enter the current date, press Ctrl-; (semicolon)
To enter the current time, press Ctrl-: (colon, i.e. Ctrl-Shift-semicolon)
These both put VALUES and not formulas, so they do not update.
"George, the neophyte" wrote
in message ...
I want to be able to enter time into a spreadsheet and freeze that cell at
the time the data was entered so that it doesn't update everytime the
sheet
recalculates. How can I do that?
Thanks,
George
|