Cell Reference Shows "0"

[Dale]

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

 

[T. Valko]

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

to be empty.

Try it like this:

=IF(Attendance!A1="","",Attendance!A1)

The cell will *appear* empty but a cell that contains a formula is *never*
empty.