topic Re: Pivot table exporting numbers to excel as text in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-exporting-numbers-to-excel-as-text/m-p/1000805#M340210 <HTML><HEAD></HEAD><BODY><P>Can you please attach a sample file (with scrambled data if necessary) in which this is occuring?</P></BODY></HTML> Tue, 22 Sep 2015 15:37:23 GMT cjohnson 2015-09-22T15:37:23Z Pivot table exporting numbers to excel as text https://community.qlik.com/t5/QlikView/Pivot-table-exporting-numbers-to-excel-as-text/m-p/1000804#M340209 <HTML><HEAD></HEAD><BODY><P>I have a number of calculated dimensions that have money amounts in them. When the pivot table is exported to excel using the "send to excel" option that appears when you right click the pivot table object;&nbsp; The money amounts are in a text format in excel.</P><P></P><P>I have used both the "Num" and the "Money" functions but nothing seams to be workings.</P><P></P><P>What do I need to do to export calculated dimensions with money values to excel that will appear in excel with the correct currency format or even as a numeric value instead of text?</P></BODY></HTML> Tue, 22 Sep 2015 11:20:56 GMT https://community.qlik.com/t5/QlikView/Pivot-table-exporting-numbers-to-excel-as-text/m-p/1000804#M340209 2015-09-22T11:20:56Z Re: Pivot table exporting numbers to excel as text https://community.qlik.com/t5/QlikView/Pivot-table-exporting-numbers-to-excel-as-text/m-p/1000805#M340210 <HTML><HEAD></HEAD><BODY><P>Can you please attach a sample file (with scrambled data if necessary) in which this is occuring?</P></BODY></HTML> Tue, 22 Sep 2015 15:37:23 GMT https://community.qlik.com/t5/QlikView/Pivot-table-exporting-numbers-to-excel-as-text/m-p/1000805#M340210 cjohnson 2015-09-22T15:37:23Z