Linking blank data with multiple datatypes

[alexandra53190]

I have a worksheet with mixed datatypes, and I need to link them to another tab. Since excel automatically fills in blank values with 0s, I have been using the following formula to link each cell:
=if(WorksheetCell="","",WorksheetCell)

This has worked out great so far, since everything is stored as a "general" datatype. But now I'm running into type conversion failures when I try to transfer the worksheets to MS Access, and I realize it's because the blank in my columns containing numbers are being stored as text (""). Is there any other way I could avoid the 0s when linking data without converting all blank values to text?

[FDibbins]

here is approach that may work for you

Use Conditional Formatting to change the font in cells with 0, to be the same as the background, so it appears thatthere is nothing in the cell

[alexandra53190]

I don't think that will solve my problem, since the 0s will still appear in Access.
Is there anyway to store a blank cell in such a way that it will not conflict with the dominant datatype in its field?