The answer is No, because using NOW Worksheet Function
will not be a constant, it will be recalculated each time that a
recalculation is done, which will be done at least when worksheet
is opened. You are thinking VB and mixing your answer into
other incorrect worksheet function responses.
See my answer earlier (in subthread below).
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Rick Rothstein (MVP - VB)" wrote in message ...
Remember, this was Teethless mama's posting that I repeated, not my own. But
to answer your question, yes, it replaces the =NOW() with the exact
date/time (down to seconds), although you might have to Custom Format
with...

mm/dd/yyyy h:mm:ss AM/PM

in order to see it. Just try it and look at the formula bar for the cell
afterwards.

Rick


"Frank Pytel" wrote in message
...
Rick;

Thanks. What does that do. Enter the function and calculate now and once
only?

Thanks

Frank Pytel

"Rick Rothstein (MVP - VB)" wrote:

You could set up the worksheet to calculate manually. This would
preclude
any updates until you choose. Unfortunately it will update when you
calculate. You could also try parsing. Choose =a1 and set to text. Try
parsing that cell.


What do you mean by parsing? If you link to another cell that will
change
the linked cell will change as well

Just to update you and Frank, this question was asked over in the
worksheet.function group also and Teethless mama gave this response...

=NOW() (press F9 instead of ENTER)

Rick