Access Report: Export to Excel getting wrong value

[veboit]

Hi,
I have 2 pages Access report. The report looks good. When I export to excel 2003 one field changing the number automatically. my first column called "order Number"
when I export to excel only one field of order number putting wrong value like -67499. this is a junk value not in my access report. Anybody knows how to correct this.
Thanks in advance.

 

[veboit]

OK got it. I found workaround for this problem in microsoft support site. here is the link

http://support.microsoft.com/?scid=kb;en-us;823222&spid=2509&sid=72