Negative number cannot display as expected in exported excel
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:
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.