Excel c# convert cell to percentage

Question

I need to convert a cell with a double to a precentage. I used a macro in excel and it says:

Range("B5").Select
Selection.Style = "Percent"

When I do this in c#, it doesn't work:

Excel.Range procentRange = xlWorksheet.get_Range("A1","A1");
procentRange.Style = "Percent";

Anybody knows how to do this?

score 18 · Accepted Answer · answered Jun 09 '10 at 13:03

18

I've found the anwser with help of JN Web

Excel.Range procentRange = xlWorksheet.get_Range("A1","A1");    
procentRange.NumberFormat = "###,##%";

So first you need a range, then set the decimals and add "%" -> automatically a 100 time multiplication

answered Jun 09 '10 at 13:03

RubenHerman

I didn't know what the actual percent format you were looking for was, glad that my mostly generic answer helped. – TheQ Jun 09 '10 at 13:05
Accepting JN Web's answer would be fair rather than accepting yours. He showed the path and u walked. :P – Sangram Nandkhile Feb 25 '13 at 09:38

score 3 · Answer 2 · answered Jun 09 '10 at 12:48

3

Try using Excel.Range.NumberFormat instead of Excel.Range.Style

answered Jun 09 '10 at 12:48

TheQ

score 0 · Answer 3 · edited Oct 04 '16 at 08:46

0

Try using Excel.Range.Style.NumberFormat.Format="#,###.00%"

edited Oct 04 '16 at 08:46

Nikolay Kostov

answered Oct 04 '16 at 08:28

Duy Trần

score -1 · Answer 4 · answered May 29 '13 at 06:36

-1

Try this procentRange.NumberFormatLocal = "0.00%"

answered May 29 '13 at 06:36

david

4 Answers4