Number format is lost when exporting to excel

[Anonymous]

I'm using a macro to Export a pivot table to Excel.  This works great except for the number formatting is not working.  In Qlikview I have my numbers formatted to #,##0 but when it exports to Excel the comma is gone. Money and percents work fine it is only the number cells that are causing a problem.  Any ideas?

[Gysbert_Wassenaar]

Export to excel only exports the data, not the formatting. You can create a macro that first exports the data and then in excel adds the formatting. See this discussion for an example document.

[Anonymous]

Thank you! I was able to find out how to change a column in the macro but I need to change just a row. Do you know the syntax for that?

[Gysbert_Wassenaar]

Not in detail. I usually try to google something like that. Perhaps these two links give you enough information to figure it out:

VBA For Microsoft Excel: The Rows of a Spreadsheet

http://www.ravisagar.in/blog/how-change-background-color-entire-row-excel-using-vba-code-conditional

[Anonymous]

Thank you!