Hi
this is only possible with VBA or manually inserting the value/date. See:
http://www.mcgimpsey.com/excel/timestamp.html

"Mcasteel" wrote:


If I use the NOW function for problem two, wont the returned date
constantly be changing? I want the returned date to be static to the
day that the record is "complted" (list box).


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=314556