Norm,

You can also do this by using a formula - for example:

=IF(F32>0,+J32/I32,"")

The "" are two quotation marks.  You can enter text within the quotations if
you want to insert in place of a blank.

Tim Klymkow

----- Original Message -----
From: Dave Gillett <[log in to unmask]>
Sent: Sunday, October 17, 1999 6:34 AM
Subject: Re: [PCSOFT] EXCEL PROBLEM


> On 15 Oct 99, at 7:38, Norm Thompson wrote:
>
> > Can anyone tell me how to put a formula in Microsoft Excel that
> > will show a blank cell instead of 0 when the cells shown in the
> > formula are blank
>
>   I *think* you can get the effect you want by "formatting" the cell
> to show blank if the value, when the formula is evaluated, is 0.
> [Note, though, that this isn't going to differentiate between  zero
> values resulting from cells with zeroes in them, and those resulting
> from blank cells being treated as zeroes....]
>
>   If you select the cells and got to Format|Cells and pick "Custom",
> you can enter a "formatting string".  A typical one is something like
> "#,##0".  If you change this to "#,###", you get something similar
> except that a zero value displays as a blank rather than as "0".
>
> David G

      "Hold No Punches.." Rode brings you great shareware/freeware
        programs with his honest opinions in this weekly column.
                         http://nospin.com/rode