Transferring from Report to Excel

M

MichaelD

When transferring data from an Access Report
using "Analyse with Excel" one of the text fields which
contains data like "7A" shows up in excel as a number
like "0.4555555". How can I prevent this from happening.
Any help would be very greatly appreciated.
Thanks
Michael
 
J

John Nurick

Hi Michael,

See the recent thread in this forum under the subject "Export to Excel".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
Mail Merge Directory Conditional Page Break 0
Integrating information from Word to Excel (not mail merge) 1
Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
VBA code in Excel opens Word template and fills bookmarks, but can't get correct formatting 5
Exporting to Excel 0
List all tables, including document structure 0

Top