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
How do I retain the text format and not allow for the number conversion?
Thanks.
Bruno