Link to an empty cell question.

H

h2fcell

Hello,

I have a cell with a link to another cell which will either be blank(empty)
or contains a number. Currently, when the source cell is empty a “0†appears
in the destination cell. If the source is empty I’d like the link to return
a null instead of “0â€.
Is there a setting to do that without using “=IF()†in the link cell?
I also would not like to use a space to clear the source cell.

Any ideas are appreciated.
 
R

Ron@Buy

An option is to hide the zero - in Excel 2003

On the Tools menu, click Options, and then click the View tab.
Do one of the following:
1. To display zero (0) values in cells, select the Zero values check box
2. To display zero values as blank cells, clear the check box.

or

You could use conditional format to change the colour of the zero to match
the background colour of the cell (assuming your cell is white):

1. Select the cell that contains the zero (0) value.
2. On the Format menu, click Conditional Formatting.
3. In the box on the left, click Cell Value Is.
4. In the second box from the left, click equal to.
5. In the box on the right, type 0.
6. Click Format, and then click the Font tab.
7. In the Color box, select white

Both these methods have been copied from Microsoft help files.

Hope this helps
 

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