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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...