=now() changed to absolute apon saving
 

please help again,
in my template i use =now(), but what happens is that if i open that
document again it's again now, which is 3 or for day later and i need to have
the original date in there.
thanks

=now() changed to absolute apon saving
 

Look he

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"des-sa" wrote in message ...
| please help again,
| in my template i use =now(), but what happens is that if i open that
| document again it's again now, which is 3 or for day later and i need to have
| the original date in there.
| thanks

=now() changed to absolute apon saving
 

NOW() is a volatile function and will continue to update.

To enter a static date hit CTRL + ;

To enter a static time hit SHIFT + CTRL + ;

Or follow the URL suggested by Bernie.


Gord Dibben MS Excel MVP

On Wed, 14 May 2008 06:31:01 -0700, des-sa
wrote:

please help again,
in my template i use =now(), but what happens is that if i open that
document again it's again now, which is 3 or for day later and i need to have
the original date in there.
thanks