topic Re: Export to Excel - Issue in QlikView https://community.qlik.com/t5/QlikView/Export-to-Excel-Issue/m-p/588949#M218409 <HTML><HEAD></HEAD><BODY><P>You could try using a macro: <A href="https://community.qlik.com/thread/89957">Number format is lost when exporting to excel</A></P></BODY></HTML> Fri, 14 Feb 2014 15:19:28 GMT Gysbert_Wassenaar 2014-02-14T15:19:28Z Export to Excel - Issue https://community.qlik.com/t5/QlikView/Export-to-Excel-Issue/m-p/588948#M218408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to export a chart with a column with different number formats. In the chart the numbers look great but when I press "Send to Excel" or right click the chart and choose the "Send to Excel" option, the exportation process converts every value in a String format with the mask I have set ('$ #,##0', '#,##0' , '#.## %', etc ) and what I wanted is to keep those formats.</P><P>The only solution I have found by now, is to "ctrl+c" the chart then paste it into an excel document, but this is too tricky for a end-user.</P><P></P><P>I am QlikView 11.20 SR5 (64 bit)</P><P></P><P>Any suggestions?</P><P></P><P>Thanks for your time.</P><P></P><P>Mensaje editado por: Ryuma Nakano</P></BODY></HTML> Fri, 14 Feb 2014 15:10:01 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Issue/m-p/588948#M218408 2014-02-14T15:10:01Z Re: Export to Excel - Issue https://community.qlik.com/t5/QlikView/Export-to-Excel-Issue/m-p/588949#M218409 <HTML><HEAD></HEAD><BODY><P>You could try using a macro: <A href="https://community.qlik.com/thread/89957">Number format is lost when exporting to excel</A></P></BODY></HTML> Fri, 14 Feb 2014 15:19:28 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Issue/m-p/588949#M218409 Gysbert_Wassenaar 2014-02-14T15:19:28Z