In L4 type =If($E$4="","",$E$4) and copy down. This means that if E4 is
blank, put in a blank, otherwise put in the content of E4.

"Dropdown3" wrote:

>
> 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
>
>