topic Re: Number format changed when sent to Excel in QlikView https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381947#M421141 <HTML><HEAD></HEAD><BODY><P>Ah, now the issue is clear. You listed it as being version 11.2, but you actually meant 12.2 - I read the number and not the text.</P><P></P><P>There's at least one formatting-export bug in 12.2, and this may be another one. I'd suggest you downgrade to 12.1 and see if that solves your problem. </P></BODY></HTML> Tue, 12 Dec 2017 09:26:48 GMT Or 2017-12-12T09:26:48Z Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381940#M421134 <HTML><HEAD></HEAD><BODY><P>Dear Qlik Community,</P><P></P><P>Since updating to QlikView 12 November from (QV 11.20) I have the problem that the number format completely changes when exporting to Excel.</P><P></P><P><IMG alt="ExportToExcel.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186425_ExportToExcel.png" style="height: 650px; width: 620px;" /><IMG alt="ExportToExcel1.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/186426_ExportToExcel1.png" style="height: 100px; width: 620px;" /></P><P>Excel Export:</P><P></P><P><IMG alt="ExportToExcel2.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/186427_ExportToExcel2.png" style="height: 190px; width: 620px;" /></P><P>Does anybody have a solution for this problem?</P><P></P><P>Kind Regards,</P><P>Manh</P></BODY></HTML> Mon, 11 Dec 2017 13:02:53 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381940#M421134 manh_nguyen 2017-12-11T13:02:53Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381941#M421135 <HTML><HEAD></HEAD><BODY><P>How you are exporting?</P></BODY></HTML> Mon, 11 Dec 2017 17:00:04 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381941#M421135 Anil_Babu_Samineni 2017-12-11T17:00:04Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381942#M421136 <HTML><HEAD></HEAD><BODY><P>Was this chart created in QV!1? if yes can you re-create the chart and check once</P></BODY></HTML> Tue, 12 Dec 2017 07:31:02 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381942#M421136 Anonymous 2017-12-12T07:31:02Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381943#M421137 <HTML><HEAD></HEAD><BODY><P>In addition to re-creating the chart as suggested by Hari, you could try explicitly formatting the expression using Num(YourExpression,'#,##0.00') - set it back to expression default and see if that works correctly. </P></BODY></HTML> Tue, 12 Dec 2017 08:27:10 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381943#M421137 Or 2017-12-12T08:27:10Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381944#M421138 <HTML><HEAD></HEAD><BODY><P>Hi, I'm exporting via the Excel Export Button.</P></BODY></HTML> Tue, 12 Dec 2017 08:28:20 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381944#M421138 manh_nguyen 2017-12-12T08:28:20Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381945#M421139 <HTML><HEAD></HEAD><BODY><P>No this was created in QV 12.20.</P></BODY></HTML> Tue, 12 Dec 2017 08:28:51 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381945#M421139 manh_nguyen 2017-12-12T08:28:51Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381946#M421140 <HTML><HEAD></HEAD><BODY><P>This is unfortunately not an option for my customer. This would lead to too many changes on their part. This was just a Demo Application from my side showing that QV 12.20 has issues with this even on the simplest level and with a native 12.20 Application.</P></BODY></HTML> Tue, 12 Dec 2017 08:30:18 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381946#M421140 manh_nguyen 2017-12-12T08:30:18Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381947#M421141 <HTML><HEAD></HEAD><BODY><P>Ah, now the issue is clear. You listed it as being version 11.2, but you actually meant 12.2 - I read the number and not the text.</P><P></P><P>There's at least one formatting-export bug in 12.2, and this may be another one. I'd suggest you downgrade to 12.1 and see if that solves your problem. </P></BODY></HTML> Tue, 12 Dec 2017 09:26:48 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381947#M421141 Or 2017-12-12T09:26:48Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381948#M421142 <HTML><HEAD></HEAD><BODY><P>Ok thank you that seems to be the only way.</P></BODY></HTML> Tue, 12 Dec 2017 13:00:28 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1381948#M421142 manh_nguyen 2017-12-12T13:00:28Z Re: Number format changed when sent to Excel https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1730583#M452261 <P>I've solved with:</P><P>Num#(Num(field,'format'))</P> Fri, 24 Jul 2020 09:41:04 GMT https://community.qlik.com/t5/QlikView/Number-format-changed-when-sent-to-Excel/m-p/1730583#M452261 nboccassini 2020-07-24T09:41:04Z