Excel 2003

I'm using transferspreadsheet function from Access 2003 to move data
to Excel. The workbook has 2 worksheets, 1 is the data from Access,
and the other is a sheet that contains formatting to display the data
in the format desired. All cells on the formatted sheet refer to the
same cell on the Access sheet. (ex: =Attendance!A1)

All cells that refer to an empty cell displays 0 (zero), I need them
to be empty.

Any ideas or suggestions? Am I going about getting a formatted sheet
in Excel with data from Access in the right fashion?

Thanks
Dale