topic Re: How to retain money format while exporting data to excel? in App Development https://community.qlik.com/t5/App-Development/How-to-retain-money-format-while-exporting-data-to-excel/m-p/1356076#M30276 <HTML><HEAD></HEAD><BODY><P>The solution is to use Money() instead of num()</P></BODY></HTML> Mon, 28 Aug 2017 08:44:01 GMT Anonymous 2017-08-28T08:44:01Z How to retain money format while exporting data to excel? https://community.qlik.com/t5/App-Development/How-to-retain-money-format-while-exporting-data-to-excel/m-p/1356074#M30274 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a chart with Sales amount in y axis. But the format of the amount i have defined using num() there.</P><P>I need to get the same format in the excel sheet when it is exported. </P><P>Any help on this would be appreciated.</P><P></P><P>Thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 04 Aug 2017 15:56:35 GMT https://community.qlik.com/t5/App-Development/How-to-retain-money-format-while-exporting-data-to-excel/m-p/1356074#M30274 Anonymous 2017-08-04T15:56:35Z Re: How to retain money format while exporting data to excel? https://community.qlik.com/t5/App-Development/How-to-retain-money-format-while-exporting-data-to-excel/m-p/1356075#M30275 <HTML><HEAD></HEAD><BODY><P>If the number format is defined on the properties panel, it should carry over when exported to excel. </P><P><IMG alt="Number Format.PNG" class="jive-image image-1" height="208" src="/legacyfs/online/172848_Number Format.PNG" style="height: 208.013px; width: 100px;" width="100" /></P></BODY></HTML> Tue, 08 Aug 2017 21:02:14 GMT https://community.qlik.com/t5/App-Development/How-to-retain-money-format-while-exporting-data-to-excel/m-p/1356075#M30275 Anonymous 2017-08-08T21:02:14Z Re: How to retain money format while exporting data to excel? https://community.qlik.com/t5/App-Development/How-to-retain-money-format-while-exporting-data-to-excel/m-p/1356076#M30276 <HTML><HEAD></HEAD><BODY><P>The solution is to use Money() instead of num()</P></BODY></HTML> Mon, 28 Aug 2017 08:44:01 GMT https://community.qlik.com/t5/App-Development/How-to-retain-money-format-while-exporting-data-to-excel/m-p/1356076#M30276 Anonymous 2017-08-28T08:44:01Z