How to not allow text to number conversion?

brunopg7

Registered User.
Local time
Today, 17:07
Joined
Apr 20, 2011
Messages
14
When I export my MS Access 2003 Report to excel, using the Analyze with Excel, the UPC text column i.e. 0023456789 00 88 converts to a number field and has the zeros truncated and some are even in scientific notation.

How do I retain the text format and not allow for the number conversion?

Thanks.
Bruno
 

Users who are viewing this thread

Back
Top Bottom