Excel formatting
 

How to format a fomulated cell when 0 leave it as blank

Thanks in advance for your help
--
MK Low

Excel formatting
 

toolsoptionsview tabwindow options untick zero value
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"MK Low" wrote:

How to format a fomulated cell when 0 leave it as blank

Thanks in advance for your help
--
MK Low

Excel formatting
 

You can hide 0's with the technique that John suggested, but there are other
ways, too.

You could change the formula so that you see what looks like an empty cell:

=if(yourformula=0,"",yourformula)

You could mask the 0 (it'll still be there) with:
Format|cells|Number tab|Custom category
General;-General;;@

(positive; negative;0's;text)

Or:

format|conditional formatting.
value is = 0
and use the same font color as the fill color (white on white?)



MK Low wrote:

How to format a fomulated cell when 0 leave it as blank

Thanks in advance for your help
--
MK Low

--

Dave Peterson