|
|
#1
09-18-2010, 09:08 AM
|
|||
|
|||
Time now--fixed?
Office '07
I wish to insert the current time within a cell simply by clicking an icon or formula name. I tried NOW but that value changes as 'now' changes. I want the inserted time to be the time as when inserted and for that time to stay that time as time passes. Is there a feature that will do that? Mark 
|
|
#2
09-19-2010, 12:05 AM
|
||||
|
||||
|
Hi Mark,
Current date: Select a cell and press CTRL+; Current time: Select a cell and press CTRL+SHIFT+; Current date and time: Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+; Cheers,
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 create letter template with fixed position fields and follow up pages
|
Lynn O'Shea | Word | 3 | 05-18-2010 12:32 AM |
| Deleting fixed name on top right of page | regularjoeback | Word | 1 | 03-23-2010 04:43 AM |
| Text Wrapping on Fixed Lines in a Form field/Table cell | okrmjr | Word Tables | 0 | 10-30-2009 08:52 AM |
|
Time is killing me!!!
|
rhale1122 | Excel | 2 | 12-02-2008 09:39 PM |
Windows 7 
Office 2007
Linear Mode
