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.

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.

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.

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.

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.

So in your change you removed the circular reference which stopped it from
updating. Read again the page to which you were referred (which explains
how the methos works), and try the method suggested there.
--
David Biddulph

"medavino" wrote in message
...
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.