Keith,
If you want a static date/time you will need to use VBA to
assign NOW() to your required cell(s).

What event determines if/when the date/time changes (as opposed to everytime
the w/book is opened)?

"Keith" wrote:

I want the date and time to be static. =NOW( ) changes everytime I open the
worksheet.

"Toppers" wrote:

use =NOW()??!!!

"Keith" wrote:

In Excel, If I format a cell with date and time and enter =today( )
I get the correct current date and a time of 12:00 AM
Never the current time. How do I get the current time?
If I enter =NOW( ) I get the correct current time.
Thanks.
Keith