Exporting nulls to Excel fails

[Mike Collard]

When I export a table containing null values to Excel the
cell appears blank but the Isblank() worksheet function
fails. This can be resolved by highlighting the
apparently blank cell, clicking F2 to edit and then
clicking Enter. The cell is then truly blank.

Although I have an Excel macro to loop through all cells
and force nulls to be null this is not a very elegant
solution and on a large spreadsheet it takes too long.

Is there a setting in Access to force nulls to be exported
as truly blank cells?

Thanks

Mike Collard