Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This may have been answered a long time ago.
When I export from a column formatted as $9,999.99, the Excel worksheet's $ format button seems to think that the default currency is KR - how can this be avoided as users are quite frustrated working on such spreadsheets?
I think you might have posted this in the wrong forum--this is primary for Server/Publisher questions.
Try this: in the object properties, go to the Number tab, select the currency dimension, select "Override Document Settings." Format the number as Money. By default, Qlikview will give you this format: $#,##0.00;($#,##0.00). Change the format to: $#,##0.00
That might fix the issue, I'm not sure.
Regards,