Learn something new everyday, and I doubled checked just to
see if that was in Excel 2002 as well as Excel 2007 and it was.
Thanks for pointing that out, that use of F9 is certainly not
intuitive but I doubt that it would cause accidental problems.

Incidentally, often such entries can be automated to create
the timestamp when the adjacent cell is updated, so much
less work using an Change Event macro if that sheet gets
a lot of new entries. The user would have to change the code
but something along the lines of
http://www.mvps.org/dmcritchie/excel...#datetimestamp

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Rick Rothstein (MVP - VB)" wrote in message ...
Look at my original post again... you type =NOW(), but you key-in F9 to
"enter" it; you do **not** use the Enter key to do so... this places the
'now' value in the cell as a constant, down to the seconds.

Rick


"David McRitchie" wrote in message
...
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