References to Blank Cells turn into Zeros

S

statusquo

Hi,

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

Thank
 
R

RagDyer

One way:

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

--
HTH,

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

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)
 
Top