I have a worksheet where the person enters the date into cell E4.Cells
L10:L60 =E4 so they don't have to type the date in every row of data. I
copy & paste this data into an Access table so that's the reason why I
have the date column along with cell E4. The problem is, when a data
isn't present in E4 the empty cells show 1/0/1900. How can I get these
cells to look empty?

-Chuck-


--
Dropdown3
------------------------------------------------------------------------
Dropdown3's Profile: http://www.excelforum.com/member.php...o&userid=30321
View this thread: http://www.excelforum.com/showthread...hreadid=508255