export access to excel produces error data is 1234-5 gets -12345

P

PITB1

When exporting an Access Report to Excel, there is an error in data transfer.
1234-5 turns into -12345 the only solution so far is to put " ' " & in front
of it which produces '1234-5. How can we get the data to show up correctly
with out having to go into Excel and then TRIM the ' off?
 
Top