Good morning,

How can I make the now() function static?

What I am trying to do is we submit our timesheet every week. I have a
macro set up to write the date that submit in Cell F1 using now(). The
problem is when we open the same timesheet next time, the date will change to
that current date.

I want the date to be the same date that I submit my timesheet and want the
date to be in the format "10/26/05". I tried using quotes around the now()
function, and it returns value instead of date.

Any other suggestions are welcomed. Thanks.