Print this page

After Exporting Reports to excel the percent sign disappears in the exported report

Knowledge Article Number 000206326
Description When a report is exported, any field of percent field type will lose the percent sign after the report is exported to excel. Example, a percent field with the value 4% will show as only 4 in the excel.
Resolution WORKAROUND:

Instead of using Export Details, choose the button Printable View.  From the option to open or Save, best is to use save.  The file can be saved as .xls which can be opened in MS Excel.

Percent symbol will be retained in the saved excel

NOTE:  Using printable view only 2000 records can be saved.

Below is the Ideaexchange link:

https://success.salesforce.com/ideaView?id=08730000000bjdsAAA




promote demote