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

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

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

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

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

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

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

Thanks for all the replies. Every example listed worked.

-Chuck-


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