------ Register to get rid of these "In Post" ads! ------


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

------ Register to get rid of these "In Post" ads! ------


Maybe this:

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

Regards,
Per

"Lenny" <Lenny@discussions.microsoft.com> skrev i meddelelsen
news:6874E613-EC29-4475-BA96-5E67BB53AFA3@microsoft.com...
> 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

------ Register to get rid of these "In Post" ads! ------


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

------ Register to get rid of these "In Post" ads! ------


Hello Lenny,

You have several additional options here.

FIRST, the Excel options include an option in one of the display sections to
suppress zero values on the worksheet. This will suppress the display of
any zero "0" result in the entire worksheet, provided this is what you want.
In Excel 2007, uncheck the option found on the menu option under 'Office
Button (marble sized button on left of Excel menu bar) > Excel Options
button > Advanced > Display options for this worksheet > Show a zero in
cells that have a zero value'.

SECOND, you also have the option of creating a custom number format that
will suppress the display of a zero value. Select the group of cells you
want to suppress the zeros for and then right-click and select the option to
'Format Cells'. In this dialog choose the number tab and select the desired
format. Once you have highlighted the desired format, then select the
custom format item. You can now see the actual format for the format chosen
to begin with and edit the format. This format, if a number format, can
have four sections divided by semi-colons (positve values; negative values;
zero values; text). The third section controls the display of the zero
values in a cell. For example, if the custom format for the number is
#,##0.00_);[Red](#,##0.00);"" then the last section showing two quotes ("")
will suppress the display of any zero value.

Hope this is clear enough. If not, please reply.

Richard

******************************
"Lenny" <Lenny@discussions.microsoft.com> wrote in message
news:6874E613-EC29-4475-BA96-5E67BB53AFA3@microsoft.com...
> 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