Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=now()
Hello,
How do (is there a way) to write = NOW( ) so that the date will become static once the Excel sheet is opened? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=now()
You'll have to "copy and paste special / values" the NOW() once it is
entered. You can either do that manually or use a macro (Workbook open event may work) is up to you. "Jim" wrote: Hello, How do (is there a way) to write = NOW( ) so that the date will become static once the Excel sheet is opened? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=now()
Check out
http://www.mcgimpsey.com/excel/timestamp.html In article , Jim wrote: Hello, How do (is there a way) to write = NOW( ) so that the date will become static once the Excel sheet is opened? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=now()
Insert a static date or time
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+; -- paul remove nospam for email addy! "Jim" wrote: Hello, How do (is there a way) to write = NOW( ) so that the date will become static once the Excel sheet is opened? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=NOW() Time Function. I want this to be live! | Excel Worksheet Functions | |||
About =now() function | Excel Discussion (Misc queries) | |||
possible to have =now() at data entry and not update after that? | Excel Worksheet Functions | |||
Display summary sheet with Now or Today data. | New Users to Excel |