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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NOW() function that won't change 4
How to freeze NOW() 4
Freeze Panes loss 3
One-time NOW() function 3
How do I freeze individual cells with formulas in them 3
Daily Time Sheets with Rounding 1
How do I get a macro or excel function copy a value on date 1
Using the NOW() function without it recalculating 3

Back
Top