Excel c# convert cell to percentage
22,328
Solution 1
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
Solution 2
Try using Excel.Range.NumberFormat
instead of Excel.Range.Style
Author by
RubenHerman
Updated on October 04, 2020Comments
-
RubenHerman over 3 years
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?