=now() changed to absolute apon saving

D

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
 
N

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
 
G

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
 
Top