I have managed to import numeric cells to excel as currencies, but now I want to do it as percent. The export process is working nicely, but when I use percent format 0.00% the value is being multiplied by 100. The code that I use is shown below:

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[i].CellFormat.FormatString = “0.00%”.

  For example, if I try to Export 105.25, then the excel is showing 10525.00%.

 How could avoid this. Is there any setting????

Please help.

Applied Network Solutions