View the original community article here
Last tested: Nov 8, 2017
Problem:
When exporting currency measure to Excel .iqy file,
Basically the "." is treated as thousand separator.. so "€4555.956" is converted to "€4555956".
Solution:
In the Excel Settings:
Excel Options > Advanced:
- Disable "Use System Separators"
- Set "." as decimal separator and "," for thousand separator
Just a note, in the .iqy url, make sure to apply the argument apply_formatting=false.
This content is subject to limited support.