https://community.qlik.com/t5/QlikView/values-and-percentage-changes-after-export-to-excel/m-p/1820922#M1213489 <P><EM>I think this is know bug , you could resolve it by using the <STRONG>money()</STRONG> function don't use num() or the formatting option in the chart properties , this will solve yyour issue</EM></P> Fri, 09 Jul 2021 08:11:13 GMT avinashelite 2021-07-09T08:11:13Z https://community.qlik.com/t5/QlikView/values-and-percentage-changes-after-export-to-excel/m-p/1820913#M1213485 <P>Hi Experts</P><P>I am facing problem with hours. Please check the highlighted column of snapshot.</P><P>The value changes after exporting.&nbsp; why i am facing problem. Please suggest me how to reslove this</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bhagi_0-1625816551784.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/58302i9DA292731C9EDE3F/image-size/medium?v=v2&amp;px=400" role="button" title="bhagi_0-1625816551784.jpeg" alt="bhagi_0-1625816551784.jpeg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bhagi_1-1625816566380.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/58303i7EA52C5CD01A1C49/image-size/medium?v=v2&amp;px=400" role="button" title="bhagi_1-1625816566380.jpeg" alt="bhagi_1-1625816566380.jpeg" /></span></P><P>&nbsp;</P> Fri, 09 Jul 2021 07:45:51 GMT https://community.qlik.com/t5/QlikView/values-and-percentage-changes-after-export-to-excel/m-p/1820913#M1213485 bhagi 2021-07-09T07:45:51Z https://community.qlik.com/t5/QlikView/values-and-percentage-changes-after-export-to-excel/m-p/1820922#M1213489 <P><EM>I think this is know bug , you could resolve it by using the <STRONG>money()</STRONG> function don't use num() or the formatting option in the chart properties , this will solve yyour issue</EM></P> Fri, 09 Jul 2021 08:11:13 GMT https://community.qlik.com/t5/QlikView/values-and-percentage-changes-after-export-to-excel/m-p/1820922#M1213489 avinashelite 2021-07-09T08:11:13Z https://community.qlik.com/t5/QlikView/values-and-percentage-changes-after-export-to-excel/m-p/1821168#M1213527 <P><U>It appears that cell&nbsp;values&nbsp;are&nbsp;exported&nbsp;in native mode, which means that the&nbsp;percentage&nbsp;format is applied to the corresponding cell in MS&nbsp;Excel.</U></P><P>&nbsp;</P><P><U><A href="https://www.telldunkin.me" target="_self"><FONT color="#333333">telldunkin</FONT></A></U></P> Tue, 13 Jul 2021 03:56:35 GMT https://community.qlik.com/t5/QlikView/values-and-percentage-changes-after-export-to-excel/m-p/1821168#M1213527 Katiely6295 2021-07-13T03:56:35Z