Data translation error exporting to Excel

I have uncovered a problem exporting data from an Access Report to Excel. I
have an equipment part number 020-0005-0000 that when exported from an Access
Report appears as 36666 in the Excel Spreadsheet. The translation error does
not occur when exporting the query to Excel, only when exporting the Report.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12881-data-translation-error-exporting-to-excel.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12881

Is there an options setting in Access or Excel that I need to change to keep
this translation from happening?

Thanks.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!