Linked cells - why '0' when blank?

L

Lynn

I have a summary sheet & 2 detail sheets in the same workbook. I want the
header info from the summary sheet to copy to the 2 detail sheets. I've
linked the cells, but the problem is - when the summary sheet cell is blank,
the cells on the detail sheets show a '0'. Hwo can I get them to stay blank?
 
E

Eduardo

Hi,
click in the Microsoft button, Excel options, advance,Display options for
this workbook, uncheck Show a Zero in cell that have zero value

if this helps please click yes, 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

Top