software

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: www.excelforum.com/member.php...oamp;userid=29501
View this thread: www.excelforum.com/showthread...hreadid=492931One way:

=IF(Sheet1!A1lt;gt;quot;quot;,Sheet1!A1,quot;quot;)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;statusquoquot; gt; wrote
in message ...
gt;
gt; Hi,
gt;
gt; This is really annoying, but whenever I make a reference to a blank
gt; cell, it turns into a zero, not a blank cell. Is there any easy way to
gt; fix this?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; statusquo
gt; ------------------------------------------------------------------------
gt; statusquo's Profile:
www.excelforum.com/member.php...oamp;userid=29501
gt; View this thread: www.excelforum.com/showthread...hreadid=492931
gt;
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: www.excelforum.com/member.php...oamp;userid=29501
View this thread: www.excelforum.com/showthread...hreadid=492931Of course will not work if you really want to view quot;realquot; 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 toolsgt;optionsgt;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)quot;statusquoquot; gt; wrote
in message ...
gt;
gt; That will work, but it's a real pain to write that every time,
gt; especially when I'm using an indirect to a different sheet, so the
gt; formula gets extremely long. Is there some sort of formatting option
gt; that can help fix this for me?
gt;
gt;
gt; --
gt; statusquo
gt; ------------------------------------------------------------------------
gt; statusquo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29501
gt; View this thread: www.excelforum.com/showthread...hreadid=492931
gt;