this works perfectly except that when I enter something in the cells it makes
the time the same for all the cells. I need every cell to have it's own
actual date and time.


"Celt" wrote:


try this formula in the cell where you want the date and time to appear.
make sure the cell is formatted for Dates.

=if(-cell-<0,NOW(),"")

where -cell- is the cell reference of where you are entering your data.


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=536454