Linking sheets how do I display the zeros (0) as blank cells

K

kat106

I have a blank cell on the first worksheet that I am linking to a second
worksheet - when I link the two worksheets the blank cell now displays a zero
(0) on the linked sheet (second worksheet). I want this linked cell to be
displayed as blank with no zero (0) in the cell, how can I do this?
 

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