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

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

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