View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default =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