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?