Linking cells

S

Steve

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,
 
R

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,
Click to expand...

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
__________________________
 
S

Steve

Yes, that was a zero, sorry.

Richard Buttrey said:
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
__________________________
Click to expand...
 
Top