Could some one help if possible,

I have an access database that draws data from an ODBC connection and sends
it Excel.

The problem arise when certain data is returned, there is are some values
that are codes e.g 16D32 , 11E23, that when they are returned to Excel ,
excel handles them as some kind of mathematical function and they are
displayed as 1.6E+33 and 1.1E+24

If you format a cell manually to be a text cell and type these values in it
is ok but on a generalised cell you get this problem, The problem is the
automatic transfer from access to excel won't let me format this type of data
as text.

Any workarounds or ideas would be great

Thanks

Jai