topic Re: Number format is lost when exporting to excel in QlikView https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520471#M1144209 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 22 Aug 2013 18:57:18 GMT Anonymous 2013-08-22T18:57:18Z Number format is lost when exporting to excel https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520469#M1144207 <HTML><HEAD></HEAD><BODY><P>I'm using a macro to Export a pivot table to Excel.&nbsp; This works great except for the number formatting is not working.&nbsp; 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.&nbsp; Any ideas?</P></BODY></HTML> Thu, 22 Aug 2013 18:29:12 GMT https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520469#M1144207 Anonymous 2013-08-22T18:29:12Z Re: Number format is lost when exporting to excel https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520470#M1144208 <HTML><HEAD></HEAD><BODY><P>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 <A _jive_internal="true" href="https://community.qlik.com/message/280316">this discussion</A> for an example document.</P></BODY></HTML> Thu, 22 Aug 2013 18:51:55 GMT https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520470#M1144208 Gysbert_Wassenaar 2013-08-22T18:51:55Z Re: Number format is lost when exporting to excel https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520471#M1144209 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 22 Aug 2013 18:57:18 GMT https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520471#M1144209 Anonymous 2013-08-22T18:57:18Z Re: Number format is lost when exporting to excel https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520472#M1144210 <HTML><HEAD></HEAD><BODY><P>Not in detail. I usually try to google something like that. Perhaps these two links give you enough information to figure it out:</P><P><A href="http://www.functionx.com/vbaexcel/topics/rows.htm" title="http://www.functionx.com/vbaexcel/topics/rows.htm">VBA For Microsoft Excel: The Rows of a Spreadsheet</A></P><P><A href="http://www.ravisagar.in/blog/how-change-background-color-entire-row-excel-using-vba-code-conditional">http://www.ravisagar.in/blog/how-change-background-color-entire-row-excel-using-vba-code-conditional</A></P></BODY></HTML> Thu, 22 Aug 2013 19:07:59 GMT https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520472#M1144210 Gysbert_Wassenaar 2013-08-22T19:07:59Z Re: Number format is lost when exporting to excel https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520473#M1144211 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Thu, 22 Aug 2013 19:09:43 GMT https://community.qlik.com/t5/QlikView/Number-format-is-lost-when-exporting-to-excel/m-p/520473#M1144211 Anonymous 2013-08-22T19:09:43Z