I have created an Excel spreadsheet that pulls information out of tables in
Access to use in calculations in excel. 99% of this data is numeric, but
there are a few exceptions. Because of this, I think I need to store the
data in Access as text data, and then have excel convert it to numeric data
as it pulls it for the 99% of records that are numeric. The 1% that are
text entries need to be pulled in as text. I've already set up my formulas
in Excel with IF statements to repress error displays, so I'm not worried
about the formulas that will try to perform mathematical operations on the
text.

My problem is, I don't even know how to approach this problem. I've never
done anything remotely like datatype conversion in Excel, much less doing it
on-the-fly while pulling from Access. Can anyone point me in the right
direction?

FYI, I'm using Office 2000.

Thanks,

Bryan