Discussion Board for collaboration on QlikView Scripting.
I have a qvw report where number column has a decimal separator as comma(,). While taking export into excel it shows dot(.) instead of comma(,). How can we see , in excel on taking export ?
Go to Solution.
May be something like below..
Click the Microsoft Office Button , and then click Excel Options.
On the Advanced tab, under Editing options, clear the Use system separators check box.
Type new separators in the Decimal separator and Thousands separator boxes.
TIP When you want to use the system separators again, select the Use system separators check box.
NOTE For a permanent solution, you must change the regional settings in Control Panel.
Did you check your configuration in Excel?
Thanks, it helped .