I want to keep my formatting when exporting to Excel using a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I export a query to Excel using a macro I lose formatting such as
percent, number of decimal places, etc. How do I keep this using a macro?
 
Sadly, you can't. You will have to do your formatting in Excel.

The only other way to do this is to use Automation and manipulate the
formatting using VBA.
 
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? 4
export teble to text keeping number format 2
How do I keep leading zeros and remove the decimal point when expo 2
Best Gmail Backup Tool to use in 2025? 3
Exporting pivot tables 2
Export Roster to Excel - Losing Phone Format 1
Macro to export query to Excel 2
exporting as text cutting off significant digits 2

Back
Top