Don't want a return of Zero - 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2003
I have 5 worksheets. Worksheet number 5 is pulling data from the 4 other
sheets.
For instance a cell in Sheet 5 says: ='Sheet1'!A8:E8
Sometimes there won't be any data in there. The formula on Sheet 5 shows a
value of 0. That is right, but is there a way to tell Excel if the value is 0
to not display anything? I don't want to print out Sheet 5 with a whole bunch
of (0's) in it.

Thank you!
 
Back
Top