I'm doing a simple spreadsheet with a few child sheets that point back to a
parent sheet with an overview of information. I've set of cells in the
parent sheet to simply look at another cell in the child sheet and copy it
across (eg =Sheet2!B3). The problem that I've got is that when cell B3 in
sheet 2 is blank it the cell in the parent sheets comes out with 0. Can
anyone tell my how to change the cell format so that it's just blank like the
child sheet.

Thanks