|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 26th, 2005, 02:20 AM
|
|||
|
|||
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
April 26th, 2005, 02:34 AM
|
|||
|
|||
|
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
April 26th, 2005, 03:09 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
| time zone & apt times auto changing | Mary | Calendar | 6 | May 25th, 2004 05:44 AM |
| Excel Time Function | Claire | Worksheet Functions | 3 | May 11th, 2004 09:51 PM |
| Time Function help | Worksheet Functions | 1 | February 3rd, 2004 03:43 AM | |
| Time Sheet function | John Logan | Worksheet Functions | 3 | October 7th, 2003 07:26 AM |
Linear Mode
