How to format decimal numbers as percentage in excel using epplus?

c# excel percentage epplus
Pandiyan Cool picture Pandiyan Cool · May 3, 2015 · Viewed 9.3k times · Source

I'm using following code to format decimal number as percentage in excel using Epplus. I have used this example.

sheet.Cells["B:B"].Style.Numberformat.Format = "#0\\.00%";

The number is looking normal in sheets, but in edit bar number is looking different.

The number 9.47% is showing as 947 in edit bar.

Check the image for problem sample. How to resolve this?

enter image description here

Answer

Jordan Biserkov picture Jordan Biserkov · May 3, 2015

Short answer: divide the numbers by 100 and use the following custom format 0.00%

Related questions

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

How can I create an Excel spreadsheet with C# without requiring Excel to be installed on the machine that's running the code?

Read More
How to export DataTable to Excel

How can I export a DataTable to Excel in C#? I am using Windows Forms. The DataTable is associated with a DataGridView control. I have to export records of DataTable to Excel.

Read More
Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've …

Read More