hi david.
once the function NOW is used it automatically updated when s/s is open or
f9, etc.
i used their formula
=IF(A1="","",IF(B1="",NOW(),B1))
my formula is
=IF(AL3=1,NOW(),"")

"David Biddulph" wrote:

Which of the methods suggested there are you using? Don't they each remain
constant? Perhaps you need to look again at your modifications.
--
David Biddulph

"medavino" wrote in message
...
thank you. with modifications it works except that i need the date/time
to
enter and then become constant and not update.
is that possible?

"T. Valko" wrote:

See if this helps:

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

--
Biff
Microsoft Excel MVP


"medavino" wrote in message
...
i am using excel 2003 and need to automatically insert date into a cell
when
i update info in a row.
others need to know how current data in a row is.
any thoughts out there?
please keep in mind that although not a total beginner, certain areas
in
excel i have never used.
thanks in advance.