Hi Danno

Try...

Tools | Options | View | Window Options | uncheck Zero Values


"Danno" wrote in message
...
Good day. I am using Excel 2002 and consider myself an above average user.
I have a worksheet that computes my pricing for my store based on the
products used to create an item for sale. There are close to 100 items that
use a standard product price worksheet.

There are several places in each of the worksheets where no values may be
necessary. To keep these cells from showing a zero amount or a zero
quantity, I have included the following preface to most of the cell
formulas;

Cell G6 contains the formula = IF C6="","",E6*F6

The formula above looks at cell C6 and if there is no entry in that cell,
then I want no value to be shown in cell G6.

Is there a way to format the entire worksheet to prevent zero values from
showing? Or is there a better way to accomplish my goal?

Thanks in advance to those who answer, Danno...