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.|
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: