topic Re: format number in excel in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/format-number-in-excel/m-p/1371721#M18393 <HTML><HEAD></HEAD><BODY><P>That is exactly it.&nbsp; Had it at auto in the Sense table and I was looking at the totals thinking I had it as a number.</P><P></P><P>Its working now.</P></BODY></HTML> Fri, 05 May 2017 12:21:26 GMT ogster1974 2017-05-05T12:21:26Z format number in excel https://community.qlik.com/t5/Qlik-NPrinting/format-number-in-excel/m-p/1371719#M18391 <HTML><HEAD></HEAD><BODY><P>Im currently generating an excel report in NP17.3</P><P></P><P>The table im sourcing the data from in Qlik Sense has this value as a number.&nbsp; Im totaling on it and Qlik is seeing it fine.</P><P></P><P>In NPrinting im creating my own table and applying my own formats to it and it wont take.&nbsp; It keeps treating it as text. Any ideas?</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162326_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>I dont want to use the source format as its not presented how I want.</P></BODY></HTML> Fri, 05 May 2017 10:30:28 GMT https://community.qlik.com/t5/Qlik-NPrinting/format-number-in-excel/m-p/1371719#M18391 ogster1974 2017-05-05T10:30:28Z Re: format number in excel https://community.qlik.com/t5/Qlik-NPrinting/format-number-in-excel/m-p/1371720#M18392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Go to presentation change its format to number from expression default.</P><P></P><P>Regards,</P></BODY></HTML> Fri, 05 May 2017 10:37:45 GMT https://community.qlik.com/t5/Qlik-NPrinting/format-number-in-excel/m-p/1371720#M18392 PrashantSangle 2017-05-05T10:37:45Z Re: format number in excel https://community.qlik.com/t5/Qlik-NPrinting/format-number-in-excel/m-p/1371721#M18393 <HTML><HEAD></HEAD><BODY><P>That is exactly it.&nbsp; Had it at auto in the Sense table and I was looking at the totals thinking I had it as a number.</P><P></P><P>Its working now.</P></BODY></HTML> Fri, 05 May 2017 12:21:26 GMT https://community.qlik.com/t5/Qlik-NPrinting/format-number-in-excel/m-p/1371721#M18393 ogster1974 2017-05-05T12:21:26Z