displaying an empty cell

L

Lynn

I used to reference cells in our worksheets (e.g. =Sheet1!C6). if
Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank
cell if Sheet1!C6 is an empty cell?

thanks
 

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

Similar Threads

display an empty cell 3
Value from one sheet paste under same value on other sheet. 7
Making a cell mandatory if another cell has a particular value 9
Saving Workbook 1
pull in cell text to referrence sheet name in formula 3
Reference a cell in criteria range 2
Need Macro... 8
Hi-Lite "empty" unlocked cells in non-hidden rows 4

Top