I want to keep my formatting when exporting to Excel using a macro Carolla 18.09.2006 18:55:02 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?

RE: I want to keep my formatting when exporting to Excel using a macro Klatuu 18.09.2006 20:10:02 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. "Carolla" wrote: [Quoted Text] > 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?