View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ewout Ewout is offline
external usenet poster
 
Posts: 6
Default Cell with zero to appear as empty

Dear Bob,

Was already aware of that option, but then zero still appears in a graphic.
The answer of RagDyer gave me what I needed. Thanks for the effort, though!
--
Ewout


"Bob Phillips" wrote:

ToolsOptionsView uncheck Zero values.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ewout" wrote in message
...
Is it possible in Excel 2003 to make a cell with a formula, that has the
outcome zero, to appear as an empty cell? I am making a line graphic but I
want the cells with zero not added in the graphic. How is this possible?
--
Ewout