I guess that is because Excel translate that field as number type, instead
od text type.
A thought without text, but worth to try:
Go to the table in Access, which the mentioned report queries against, and
change the value on that field to an explicit text value (only one row),
say, change "0001" to "AAA1". Then run the report and convert the report to
Excel work sheet. This, I believe, will lead Excel to translating that field
into text type. Finally, open the *.xls file and correct the "AAA1" back to
"0001".
Pete Montero said:
Hi I have a problem, I am converting an access report to Excel, and I have
a field with numbers, they are entered as text, and they start from 0001 to
1000, so when I export the report to Excel this field shows 1, 2, 3, etc.
without the zeros. Does anyone knows why is it doing that?
