How to append % symbol in numbers format without multiplying by 100 in ClosedXML

Question

When I set format of a cell as %, and Export it automatically multiply the value with 100 & show the value. So 1.9 becomes 190%, I have use this code to add Symbol of %.

worksheet.Cell(2, 2).Style.NumberFormat.SetFormat("0.00%");

Can anybody help me to solve this?

It looks like your question has been answered here: [StackOverflow Link](http://stackoverflow.com/questions/7872116/applying-number-format-to-a-cell-value-using-openxml) — noctural, Oct 19 '15 at 15:14
@SonerGönül yes support standard numeric format string, and as a result i just want 1.9% instead of 190%. — Smit Patel, Oct 19 '15 at 15:34

score 6 · Accepted Answer · answered Oct 22 '15 at 06:24

Finally Got a solution by Own. You can do it in a simple way. If you want to apply it on single cell then do this,

worksheet.Cell(9, 10).Style.NumberFormat.Format = "#,##0.00\\%";

And If you want to apply it on a Range of Cells then do this,

worksheet.Range(9, 10, 15, 10).Style.NumberFormat.Format = "#,##0.00\\%";

you can also find more formats Here, and also you can find the same from Excel as well.

score 0 · Answer 2 · answered Jul 29 '21 at 12:37

0

it worked for me but I used "#,##0.00%" instead of "#,##0.00\%"

answered Jul 29 '21 at 12:37

AleM

61
1
4

How to append % symbol in numbers format without multiplying by 100 in ClosedXML

2 Answers2