topic Re: Maintaining number formatting in Straight Table Export in QlikView https://community.qlik.com/t5/QlikView/Maintaining-number-formatting-in-Straight-Table-Export/m-p/1303705#M406026 <HTML><HEAD></HEAD><BODY><P>Hi James,</P><P></P><P>Maybe this will help you <A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm">Num ‒ QlikView</A></P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Wed, 24 May 2017 14:36:12 GMT ahaahaaha 2017-05-24T14:36:12Z Maintaining number formatting in Straight Table Export https://community.qlik.com/t5/QlikView/Maintaining-number-formatting-in-Straight-Table-Export/m-p/1303704#M406025 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Why doesn't qlikview maintain number formatting when exporting a simple straight table to excel via macro?&nbsp; I have numbers with standard thousand-comma-separators (12,345.00) and 100% of the time they are exported as 12345.00.&nbsp; I have tried multiple different number formats within the straight table itself and still they always export without any commas or anything.&nbsp; Money tends to export just fine.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I am assuming i need to add something to the vbscript? Because when i use the built-in Export to Excel on my straight tables, they export correctly.&nbsp; Is there any particular vbscript code or other setting folks implement to ensure straight table numbers maintain their formatting when macro-exported to excel?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks!</SPAN></P><P><SPAN style="font-size: 10pt;">James<BR /></SPAN></P></BODY></HTML> Fri, 19 May 2017 16:54:54 GMT https://community.qlik.com/t5/QlikView/Maintaining-number-formatting-in-Straight-Table-Export/m-p/1303704#M406025 jjohnstonti618 2017-05-19T16:54:54Z Re: Maintaining number formatting in Straight Table Export https://community.qlik.com/t5/QlikView/Maintaining-number-formatting-in-Straight-Table-Export/m-p/1303705#M406026 <HTML><HEAD></HEAD><BODY><P>Hi James,</P><P></P><P>Maybe this will help you <A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm">Num ‒ QlikView</A></P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Wed, 24 May 2017 14:36:12 GMT https://community.qlik.com/t5/QlikView/Maintaining-number-formatting-in-Straight-Table-Export/m-p/1303705#M406026 ahaahaaha 2017-05-24T14:36:12Z