Linking cells
 

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,

On Fri, 9 Sep 2005 09:41:05 -0700, "Steve"
wrote:

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
__________________________

Yes, that was a zero, sorry.

"Richard Buttrey" wrote:

On Fri, 9 Sep 2005 09:41:05 -0700, "Steve"
wrote:

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
__________________________