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