Recently upgraded to 2003, a problem has started within a spreadsheet one
department has always used. They run a query in Access and then copy and
paste the results into Excel. The first worksheet is the pasted data, the
second worksheet contains a bunch of links to that data, formats it and
performs additional calculations. Since the upgrade, any field that should
be blank will place a zero in that field. This is a problem for their
calculation. They want the calculated fields to show the error, now they are
performing calculations when they shouldn't. Is there an option that says if
it's blank enter a 0 that could be turned off or how can they avoid this in
the future?

Thanks!