Linking cells

[Guest]

Good day. I have a spreadsheet linking back to another spreadsheet. The
link is working just fine, unless there is no data in the original cell,
causing a "0" to show up in the linked cell. Is there any way, other than an
if then statement to get rid of the "O" showing up in the linked cell.

Thanks,

 

[Richard Buttrey]

Good day. I have a spreadsheet linking back to another spreadsheet. The
link is working just fine, unless there is no data in the original cell,
causing a "0" to show up in the linked cell. Is there any way, other than an
if then statement to get rid of the "O" showing up in the linked cell.

Thanks,

Is this a letter "O" or zero. if it's zero you could set the sheet to
not display zero values.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

Yes, that was a zero, sorry.

Is this a letter "O" or zero. if it's zero you could set the sheet to
not display zero values.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________