Negative number cannot display as expected in exported excel

General
,
1

I want to export excel by MSOGenerateExcelFile with excel template. When I exported it ,the negative numbers or the numbers with pre-symbol in excel cannot display as expected.

Such as: negative number in excel.png

expected: -200.5

reality: '-200.5

The ’ is not expected.It seems not useful to change the cell format in the template. How can I resolve it ?

​Waiting for your reply and thanks a lot.

2

Use pxGenerateExcelFile instead of MSOGenerateExcelFile then worked OK.