Show blank cell

[Dropdown3]

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-

[Gary''s Student]

This is a very common link problem. Instead of:
=E4
use:
=if(E4="","",E4)
--
Gary's Student


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

[SVC]

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

[Sloth]

format the cell as

d/m/yyyy;;

this will make any negative or zero value show as a blank cell

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

[Mark Lincoln]

=IF(ISBLANK(E4,"",E4)

[Mark Lincoln]

Ack! I missed a parenthesis. The formula should read:

=IF(ISBLANK(E4),"",E4)

[Dropdown3]

Thanks for all the replies. Every example listed worked.

-Chuck-