=NOW() from changing

[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.

 

[JE McGimpsey]

One way:

http://www.mcgimpsey.com/excel/timestamp.html

 

[Pete_UK]

Just do CTRL-semicolon to enter today's date in a cell.

Hope this helps.

Pete

 

[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.

 

[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.

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.

 

[JE McGimpsey]

Remarkably, that's the first suggestion in the link!

<g>