Dear Qlik Community,
Since updating to QlikView 12 November from (QV 11.20) I have the problem that the number format completely changes when exporting to Excel.
Does anybody have a solution for this problem?
In addition to re-creating the chart as suggested by Hari, you could try explicitly formatting the expression using Num(YourExpression,'#,##0.00') - set it back to expression default and see if that works correctly.
This is unfortunately not an option for my customer. This would lead to too many changes on their part. This was just a Demo Application from my side showing that QV 12.20 has issues with this even on the simplest level and with a native 12.20 Application.
Ah, now the issue is clear. You listed it as being version 11.2, but you actually meant 12.2 - I read the number and not the text.
There's at least one formatting-export bug in 12.2, and this may be another one. I'd suggest you downgrade to 12.1 and see if that solves your problem.