References to Blank Cells turn into Zeros

[statusquo]

Hi,

This is really annoying, but whenever I make a reference to a blank cell, it turns into a zero, not a blank cell. Is there any easy way to fix this?

Thanks

[RagDyer]

One way:

=IF(Sheet1!A1<>"",Sheet1!A1,"")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"statusquo" <[email protected]> wrote
in message news:[email protected]...
>
> Hi,
>
> This is really annoying, but whenever I make a reference to a blank
> cell, it turns into a zero, not a blank cell. Is there any easy way to
> fix this?
>
> Thanks
>
>
> --
> statusquo
> ------------------------------------------------------------------------
> statusquo's Profile:
http://www.excelforum.com/member.php...o&userid=29501
> View this thread: http://www.excelforum.com/showthread...hreadid=492931
>

[statusquo]

That will work, but it's a real pain to write that every time, especially when I'm using an indirect to a different sheet, so the formula gets extremely long. Is there some sort of formatting option that can help fix this for me?

[Peo Sjoblom]

Of course will not work if you really want to view "real" zeros since they
will not be visible

General,-General;;

whatever number format you use end with 2 semi colons

0.00;-0.00;;

you can also turn them off via tools>options>view but that will affect the
lot, this will only affect those that you format and you can use the format
painter

--
Regards,

Peo Sjoblom

(No private emails please)


"statusquo" <[email protected]> wrote
in message news:[email protected]...
>
> That will work, but it's a real pain to write that every time,
> especially when I'm using an indirect to a different sheet, so the
> formula gets extremely long. Is there some sort of formatting option
> that can help fix this for me?
>
>
> --
> statusquo
> ------------------------------------------------------------------------
> statusquo's Profile:
> http://www.excelforum.com/member.php...o&userid=29501
> View this thread: http://www.excelforum.com/showthread...hreadid=492931
>