Show blank cell


D

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

Advertisements

G

Guest

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

Guest

format the cell as

d/m/yyyy;;

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

Mark Lincoln

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

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top