Unanswered: Export text field from an Access Report into Excel is strangely formatted
when I export Access Report (either through the Excel icon or using macro) into Excel some of the values get screwed. To be specific
0440-006 in Access turns out to be -533100 in Excel after exporting. However 0518-476 is exported correctly.
You need to know that that field is defined as text in both table and on the report. I cannot reformat it in Excel. Any thoughts are hugely appreciated. Thank you