software

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 amp; 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: www.excelforum.com/member.php...oamp;userid=30321
View this thread: www.excelforum.com/showthread...hreadid=508255This is a very common link problem. Instead of:
=E4
use:
=if(E4=quot;quot;,quot;quot;,E4)
--
Gary's Studentquot;Dropdown3quot; wrote:

gt;
gt; I have a worksheet where the person enters the date into cell E4.Cells
gt; L10:L60 =E4 so they don't have to type the date in every row of data. I
gt; copy amp; paste this data into an Access table so that's the reason why I
gt; have the date column along with cell E4. The problem is, when a data
gt; isn't present in E4 the empty cells show 1/0/1900. How can I get these
gt; cells to look empty?
gt;
gt; -Chuck-
gt;
gt;
gt; --
gt; Dropdown3
gt; ------------------------------------------------------------------------
gt; Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
gt; View this thread: www.excelforum.com/showthread...hreadid=508255
gt;
gt;

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

quot;Dropdown3quot; wrote:

gt;
gt; I have a worksheet where the person enters the date into cell E4.Cells
gt; L10:L60 =E4 so they don't have to type the date in every row of data. I
gt; copy amp; paste this data into an Access table so that's the reason why I
gt; have the date column along with cell E4. The problem is, when a data
gt; isn't present in E4 the empty cells show 1/0/1900. How can I get these
gt; cells to look empty?
gt;
gt; -Chuck-
gt;
gt;
gt; --
gt; Dropdown3
gt; ------------------------------------------------------------------------
gt; Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
gt; View this thread: www.excelforum.com/showthread...hreadid=508255
gt;
gt;

format the cell as

d/m/yyyy;;

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

quot;Dropdown3quot; wrote:

gt;
gt; I have a worksheet where the person enters the date into cell E4.Cells
gt; L10:L60 =E4 so they don't have to type the date in every row of data. I
gt; copy amp; paste this data into an Access table so that's the reason why I
gt; have the date column along with cell E4. The problem is, when a data
gt; isn't present in E4 the empty cells show 1/0/1900. How can I get these
gt; cells to look empty?
gt;
gt; -Chuck-
gt;
gt;
gt; --
gt; Dropdown3
gt; ------------------------------------------------------------------------
gt; Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
gt; View this thread: www.excelforum.com/showthread...hreadid=508255
gt;
gt;

=IF(ISBLANK(E4,quot;quot;,E4)Ack! I missed a parenthesis. The formula should read:

=IF(ISBLANK(E4),quot;quot;,E4)
Thanks for all the replies. Every example listed worked.

-Chuck---
Dropdown3
------------------------------------------------------------------------
Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
View this thread: www.excelforum.com/showthread...hreadid=508255