Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Decimal separator (,) is not appearing in excel export

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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.

View solution in original post

3 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Did you check your configuration in Excel?

MK_QSL
MVP
MVP

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.

Not applicable
Author

Thanks, it helped .