I am not an excel expert, so I do not know whether the issue I met is related to the below idea:
The issue I met is as below:
1, I formatted a data field in report designer, using “0.00”
2, It is looked nice in screen and when exporting to PDF
However, the data is only displayed in integer format, while it is indeed having 2 decimals value.
on the contrary, the data filed without formatting is looked bad on screen, but it is OK when exporting to excel
Best answer by ChandrasekharM