Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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.
Thanks, it helped .