Exporting currency in correct format

[steasy]

Hello all,

I want the following output, e.g.:

• 0 should be displayed and exported as 0 €
• 5000 should be displayed and exported as 5.000,00 €

Idea No.	Formula	Number Format	Displayed Output in Qlik Sense	Exported Output in Excel
1	=Money(round(..., .01))	Automatically	0 € 5.000,00 €	000 € 5.000 €
2	=round(..., .01)	Currency with: #.##0,00 €;-#.##0,00 €	0 € 5.000,00 €	,000 € 5000,000 €

My analytics team always export with the tick in keeping the table format, because they want to keep the colors. Therefore their output in excel is like the exported output in excel as above. Not ticking would be a solution for the decimals, but will remove the colored cells.

Why is my displayed output different to the exported output and how can I change that? 

[LRuCelver]

Your Excel and Qlik Sense are using different decimal and thousands separators. You can change them in the load script: