how do I freeze the time in the NOW() function?

  • Thread starter George, the neophyte
  • Start date
G

George, the neophyte

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
 
D

Duke Carey

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.
 
Top