View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default printing without zeros showing in a cell with formulas

I've created a workbook that totals 5 worksheets (for Monday thru Friday) on
a 6th worksheet that is printed and posted weekly. However, because there is
a formula in each cell on the weekly sheet, a zero appears in all of the
cells which makes the sheet being posted look too too busy... Is there a way
to have the weekly worksheet leave all cells blank unless there is actual
data pulled?