query export wont allow a zero value?

  • Thread starter Thread starter Vadimbar
  • Start date Start date
V

Vadimbar

I runa query and forcing a specific value with a leading zero.
i.e. 011210

When I run the export the first zero is eliminated. 11210

Any ideas why this happens? When ever I change the zero to a 1 or 2 works
perfectly.

The query always shows the correct value but the export text file is always
off. Any ideas why?

Thank you
 
If you are exporting to Excel, and this should be a text field, prepend a
single-quote to what you are exporting. Then Excel will keep the text
formatting.
 
Back
Top