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

Try to export from Access in .txt format and import this text file into Excel!

Regards,
Stefi


€žJai_Friday€� ezt Ã*rta:

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

Thanks for the input Stefi,

The helps as a temporary work around, however I need to look into a access
function (guess I will post it on the access area)

there is a Cstr function that should convert the value to a string but it
doesn't work, there probably is something else that can be used

Cheers again

Jason

"Stefi" wrote:

Try to export from Access in .txt format and import this text file into Excel!

Regards,
Stefi


€žJai_Friday€� ezt Ã*rta:

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

Hi

Are you opening the Access table/query using ODBC from within Excel - using
Get External Data?

Andy.

"Jai_Friday" wrote in message
...
Thanks for the input Stefi,

The helps as a temporary work around, however I need to look into a access
function (guess I will post it on the access area)

there is a Cstr function that should convert the value to a string but it
doesn't work, there probably is something else that can be used

Cheers again

Jason

"Stefi" wrote:

Try to export from Access in .txt format and import this text file into
Excel!

Regards,
Stefi


"Jai_Friday" ezt írta:

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