View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Cell with zero to appear as empty

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