topic Export to Excel - Keep Number Format in QlikView

topic Export to Excel - Keep Number Format in QlikView https://community.qlik.com/t5/QlikView/Export-to-Excel-Keep-Number-Format/m-p/631148#M231615 <HTML><HEAD></HEAD><BODY><P>Hi I have a variable to calculate a percentage for a pivot chart :</P><P></P><P></P><P>num(sum(Number)/sum([Line Total]),'#,##0.0%')</P><P></P><P>When I try to export the pivot to Excel all the numbers are formatted as text.  How can I keep the number format??</P><P></P><P>Many thanks,</P><P></P><P>Tom</P></BODY></HTML> Tue, 13 May 2014 10:17:37 GMT 2014-05-13T10:17:37Z Export to Excel - Keep Number Format https://community.qlik.com/t5/QlikView/Export-to-Excel-Keep-Number-Format/m-p/631148#M231615 <HTML><HEAD></HEAD><BODY><P>Hi I have a variable to calculate a percentage for a pivot chart :</P><P></P><P></P><P>num(sum(Number)/sum([Line Total]),'#,##0.0%')</P><P></P><P>When I try to export the pivot to Excel all the numbers are formatted as text.  How can I keep the number format??</P><P></P><P>Many thanks,</P><P></P><P>Tom</P></BODY></HTML> Tue, 13 May 2014 10:17:37 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel-Keep-Number-Format/m-p/631148#M231615 2014-05-13T10:17:37Z