| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
HI anyone can tell me plz how can i use (crtl+shft+semi-colon) automatically without using a keyboard????
Last edited by abdulla : April 30th 10 at 08:15 PM Reason: wrong data entering |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| unmet challenge | Excel Worksheet Functions | |||
| What function do I use to convert "time" to minutes? | Excel Worksheet Functions | |||
| Help with Time Function | Excel Worksheet Functions | |||
| Date & Time function | Excel Worksheet Functions | |||
Hybrid Mode
