Empty cell instead of 0

[Zorro]

Hi all,
In a cell, I make a copy of another cell with the formulae "=A1".
My problem is that if A1 is empty, the formulae display "0" instead of
nothing!
How can I change that?

Thank you.

[Bob Phillips]

=IF(A1="","",A1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Zorro" <zorro@vega.com> wrote in message
news:4491c04c$0$932$ba4acef3@news.orange.fr...
> Hi all,
> In a cell, I make a copy of another cell with the formulae "=A1".
> My problem is that if A1 is empty, the formulae display "0" instead of
> nothing!
> How can I change that?
>
> Thank you.
>
>

[diykid]

Hi Zorro

In case you just want to hide the 0's from view/ print, select the
cell(s) containing formulas and set conditional formatting for the
cells to font colour similar to the background e.g. white.

Format Menu > Conditional formatting > Condition 1 (Cell value is>
equal to> 0) > format

and then going to Font tab and choosing font colour as white or
whatever is your back ground.

However, the 0's are still very much there.

DIYKID



Zorro wrote:
> Hi all,
> In a cell, I make a copy of another cell with the formulae "=A1".
> My problem is that if A1 is empty, the formulae display "0" instead of
> nothing!
> How can I change that?
>
> Thank you.

[Cornelia]

Not sure if this will address your real issue, but you could use conditional
formatting to make nothing appear if cell equals zero.

"Zorro" wrote:

> Hi all,
> In a cell, I make a copy of another cell with the formulae "=A1".
> My problem is that if A1 is empty, the formulae display "0" instead of
> nothing!
> How can I change that?
>
> Thank you.
>
>
>