Linking cells

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

[Richard Buttrey]

On Fri, 9 Sep 2005 09:41:05 -0700, "Steve"
<Steve@discussions.microsoft.com> 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
__________________________

[Steve]

Yes, that was a zero, sorry.

"Richard Buttrey" wrote:

> On Fri, 9 Sep 2005 09:41:05 -0700, "Steve"
> <Steve@discussions.microsoft.com> 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
> __________________________
>