A
Arlene
How can I transfer a report from access to excel maintaining the text format?
I have a table with 9 columns, each column is used to store numbers, but they
are formated as text. The reports shows the numbers correctly, but when I
transfer the report to excel I loose the text format. The numbers stored are
something like this : 10 2240 111 000 00 000 000 000 0000 and every set of
numbers is in a different column. How can I prevent this from happening?
I have a table with 9 columns, each column is used to store numbers, but they
are formated as text. The reports shows the numbers correctly, but when I
transfer the report to excel I loose the text format. The numbers stored are
something like this : 10 2240 111 000 00 000 000 000 0000 and every set of
numbers is in a different column. How can I prevent this from happening?