Free Support Forum - aspose.com

Setting number format for cells

Hi,

How to set number format for cell which contain numbers. I have gone through the following link
for format and I have using like

style.Number = 0, then it aligned to right side of the cell.

"http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/setting-display-formats-
of-numbers-dates.html"

Please help me, how to done this.

Thanks,
Veeru1.

Hi,

"style.Number = 0, then it aligned to right side of the cell."

The behavior is same as MS Excel, you may insert some number in a cell and apply the general format. 0 - means general, if the cell contains number in it, it will be aligned to the right of the cell. If the cell contains text or alpha-numeric value, it will be on left side considering it as text.

If you want the value should be on left side, you should format the cell value as text. i.e…, … style.Number = 49

Thank you.