Cell formulas display "0" (zero's)
 

How can I get excel to not display a 0 (zero) in a cell with a simple
calculation like:
Z3+A4. I don't want the cells to display zeros before it displays the
calculation when entries are made into the formula cells and I don't want to
have to make the entries white to hide them. There's gotta be a way to not
show this value.

My thanks

Lenny

Cell formulas display "0" (zero's)
 

Maybe this:

=IF(Z3+A4<0,Z3+A4,"")

Regards,
Per

"Lenny" skrev i meddelelsen
...
How can I get excel to not display a 0 (zero) in a cell with a simple
calculation like:
Z3+A4. I don't want the cells to display zeros before it displays the
calculation when entries are made into the formula cells and I don't want
to
have to make the entries white to hide them. There's gotta be a way to
not
show this value.

My thanks

Lenny

Cell formulas display "0" (zero's)
 

Hi,
in excel 2007, click on the microsoft button, excel options at the
bottom,Advance, Display options for this worksheet, uncheck show a zero in
cells that have zero value

"Lenny" wrote:

How can I get excel to not display a 0 (zero) in a cell with a simple
calculation like:
Z3+A4. I don't want the cells to display zeros before it displays the
calculation when entries are made into the formula cells and I don't want to
have to make the entries white to hide them. There's gotta be a way to not
show this value.

My thanks

Lenny