Exporting to Excel with % Format

J

J Shrimps, Jr.

Have a query that creates a temp table
based on selection criteria from controls on form.

Using code on form to export table:
DoCmd.OutputTo acOutputTable, "tmpExport", acFormatXLS,
yadayada...

While the fields in the tmp table are formated for percentage
when the spreadsheet is opened in Excel none data in the
rows are formated for percentage.
Is there a way to format export to Excel in percent format?
 
Top