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

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.


"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

Here's a technique

http://www.mcgimpsey.com/excel/timestamp.html

--
Regards,

Peo Sjoblom


"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

HI anyone can tell me plz how can i use (crtl+shft+semi-colon) automatically without using a keyboard????