Why doesn't qlikview maintain number formatting when exporting a simple straight table to excel via macro? I have numbers with standard thousand-comma-separators (12,345.00) and 100% of the time they are exported as 12345.00. I have tried multiple different number formats within the straight table itself and still they always export without any commas or anything. Money tends to export just fine.
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. Is there any particular vbscript code or other setting folks implement to ensure straight table numbers maintain their formatting when macro-exported to excel?
Thanks!
James
