topic Decimal separator (,) is not appearing in excel export in QlikView

Decimal separator (,) is not appearing in excel export

Fri, 21 Feb 2014 12:22:13 GMT

Hi,

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 ?

Regards,

Roushan

Re: Decimal separator (,) is not appearing in excel export

jvitantonio — Fri, 21 Feb 2014 12:25:59 GMT

Did you check your configuration in Excel?

Re: Decimal separator (,) is not appearing in excel export

MK_QSL — Fri, 21 Feb 2014 12:30:18 GMT

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.

Re: Decimal separator (,) is not appearing in excel export

Fri, 21 Feb 2014 12:53:31 GMT

Thanks, it helped .