=now()
 

Hello,

How do (is there a way) to write = NOW( ) so that the date will become
static once the Excel sheet is opened?

=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?

=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?

=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?