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

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