link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am setting up a link. The souce cell is blank, but the destination cell
reads"0". How do I keep it blank?
 
You can set a custom format so 0 will not appear at all. The value will not
change just the appearance. Click "Format", choose "Cells", on the "Number"
tab find "Custom". Type the following as one possible choice:
0_);-0_);;@
 
You must log in or register to reply here.

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

Linking Cells 3
Linking sheets how do I display the zeros (0) as blank cells 1
HELP!!!!!!!!! 2
How do I get Rid of the Circumflex Accent (Caret) 2
Link to an empty cell question. 2
Help needed 0
I need a cell to be blank. 4
linked workbook cell returns 0 is source workbook cell is blank? 4

Back
Top