=now() changed to absolute apon saving

[des-sa]

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

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Gord Dibben]

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