Exporting to Excel format question

  • Thread starter Thread starter GeoDude
  • Start date Start date
G

GeoDude

I have a field in Access which is formatted is text. Here is a few
examples of the values in the field:

04033125105
04502552135

Even though there numbers I format them in text so I can keep the 0 in
front of the other numbers.

When I export to Excel I always lose the zero in front of the numbers.
I always end up having to use "concatenate" and format to text to fix
the problem. Does anyone know how I can export to Excel and keep my
formatting? I have Office 2003.

Thanks for the help.
 
Put a single quote in front of the text to ensure it doesn't get changed by
Excel.
 
You must log in or register to reply here.

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

How to Export Gmail Emails to PST Format? 5
Report Export To Excel 2
Need help exporting an Office 365 mailbox to PST 2
convert time format to decimal format for excel? 1
Access 2007 Report Formats -- Export to Excel 7
How to Convert EML to PST? 2
Leading zero's while exporting to excel 3
ACCESS = "NO" BUT EXCEL = "0" 2

Back
Top