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