Free Support Forum - aspose.com

How to add custom style property to display % symbol after a number

Hi,

I have to display '%' symbol after a number for this I'm using the custom property

percentageStyle.Custom = "\"\"0%"

fot this property the original number is mutiplied with 100 and displayed .

can you please tell me how to display % symbol after the number without multiplying with 100.

Thank you.

Hi,

Well, I think you may try to divide the num by 100 for which you want to add and display percent symbol only.

E.g.,

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook();
Aspose.Cells.Worksheet ws = wb.Worksheets[0];
double num = 35435;
ws.Cells[0,0].PutValue(num/100);
ws.Cells[0,0].Style.Custom = "0%";
wb.Save("d:\\test\\addpercent.xls");
Thank you.