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.

One way:

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

In article ,
Richard wrote:

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.

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

Hope this helps.

Pete

On Feb 28, 2:29*am, JE McGimpsey wrote:
One way:

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

In article ,



*Richard wrote:
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.- Hide quoted text -

- Show quoted text -

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.


--
Anil showreddy


"Richard" wrote:

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.

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

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

<g

In article
,
Pete_UK wrote:

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

Hope this helps.

Pete

On Feb 28, 2:29*am, JE McGimpsey wrote:
One way:

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