=NOW() from changing

R

Richard

I can't remember how I did it before but I add something to the now() formula
to keep the date from changing, can anyone help? If(b2="","",Now()) or some
condition as such once the date is entered it won't change.
 
A

Anil showreddy

to say frankly i could not get ur question... ur if condition will work but
after entering formula u need to change the format for cell in custom
m/d/yyyy h:mm

then the value will converts into given format..

and it will not update the value(date and time) untill you close and open
the file.
 
S

Stan Brown

Wed, 27 Feb 2008 18:15:02 -0800 from Richard
I can't remember how I did it before but I add something to the now() formula
to keep the date from changing, can anyone help? If(b2="","",Now()) or some
condition as such once the date is entered it won't change.
Click to expand...

As far as I'm aware, there is no way to keep NOW() from being re-
evaluated, if it's in the cell as a formula.

Instead, click in to the cell and type
Ctrl-semicolon
then
(the space bar, once)
then
Ctrl-colon (a/k/a/Ctrl-Shift-semicolon)
then
(the Enter key)

This puts the current date and time into the cell as a constant,
which will not change.
 
Top