View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Suppressing zero value display in print-out

You should be able to suppress these: Tools Options, select the View tab
and clear the checkbox for 'Zero Values.'
However, I would have expected the conditional formatting to work as well.
Are you certain the result is precisely 0? If not, you'll likely have better
luck with conditional formatting, applying the format if the value is, say,
between -0.0000001 and +0.0000001.
--Bruce

"Gary D." wrote:

How do I not print 0.000 values.

I am able to hide zero values on the screen with conditional formatting, but
when I print the sheet the zero value cells are printing 0.000, I would like
to have the cells with 0.0000 in them print blank.

Thanks Gary D.