Hey All,

Im having a bit of an issue. In a excel sheet in the colum i have some
numbers that are copied from another data source. When these are copied into
the sheet Sometimes the cells are blank and hence are preventing the formulas
throughout the workbook to display a #value.(=Summary!F74/Summary!$G74) will
display #value as Summary!F74 is a blank cell

Is there a way I can either make all blank cells have a 0 in them easily or
ignore the error message

i.e.
190

23

3
2
2

18
1
2
2
9
2
3

Thanks