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
******************************
