topic Percent Formatting and Number Presentation in Excel in QlikView https://community.qlik.com/t5/QlikView/Percent-Formatting-and-Number-Presentation-in-Excel/m-p/264168#M99342 <HTML><HEAD></HEAD><BODY><P>I'm posting this here as this has been a problem for me for quite some time.&nbsp; There are other posts in Community Forums that helped me arrive at this solution, although based on how long it took me to find the answer, I thought I'd help people who also had difficulty finding the right solution.</P><P></P><P>The problem is: Excel does not preserve Percent formatting when a chart has been exported.</P><P></P><P>The solution is:</P><OL><LI>Open Chart properties</LI><LI>Go to the "Number" tab</LI><LI>Choose the expression you wish to format as a percentage (both in QlikView and Excel)</LI><LI>Change the number format Settings to "Integer"</LI><LI>Check the "Show in Percent (%)" box</LI><LI>Change the "Format Pattern" to be "#,##.#%"</LI><LI>Click OK to save these property changes</LI></OL><P></P><P>I have tested this both on QVS 9 SR7 and QV10 SR3, exporting to Excel 2007.</P></BODY></HTML> Thu, 20 Oct 2011 15:22:17 GMT 2011-10-20T15:22:17Z Percent Formatting and Number Presentation in Excel https://community.qlik.com/t5/QlikView/Percent-Formatting-and-Number-Presentation-in-Excel/m-p/264168#M99342 <HTML><HEAD></HEAD><BODY><P>I'm posting this here as this has been a problem for me for quite some time.&nbsp; There are other posts in Community Forums that helped me arrive at this solution, although based on how long it took me to find the answer, I thought I'd help people who also had difficulty finding the right solution.</P><P></P><P>The problem is: Excel does not preserve Percent formatting when a chart has been exported.</P><P></P><P>The solution is:</P><OL><LI>Open Chart properties</LI><LI>Go to the "Number" tab</LI><LI>Choose the expression you wish to format as a percentage (both in QlikView and Excel)</LI><LI>Change the number format Settings to "Integer"</LI><LI>Check the "Show in Percent (%)" box</LI><LI>Change the "Format Pattern" to be "#,##.#%"</LI><LI>Click OK to save these property changes</LI></OL><P></P><P>I have tested this both on QVS 9 SR7 and QV10 SR3, exporting to Excel 2007.</P></BODY></HTML> Thu, 20 Oct 2011 15:22:17 GMT https://community.qlik.com/t5/QlikView/Percent-Formatting-and-Number-Presentation-in-Excel/m-p/264168#M99342 2011-10-20T15:22:17Z Percent Formatting and Number Presentation in Excel https://community.qlik.com/t5/QlikView/Percent-Formatting-and-Number-Presentation-in-Excel/m-p/264169#M99343 <HTML><HEAD></HEAD><BODY><P>I never would have guessed to use "Integer".&nbsp; Thanks for sharing!&nbsp; </P></BODY></HTML> Tue, 01 Nov 2011 16:25:29 GMT https://community.qlik.com/t5/QlikView/Percent-Formatting-and-Number-Presentation-in-Excel/m-p/264169#M99343 BarbCline 2011-11-01T16:25:29Z