Formatting Numbers as Text

[Administrator]

Many of our account numbers have leading zeros. I'd like to be able to format the account number column as text so that 001 shows up in the spreadsheet as 001 and not 1. This is particularly helpful if the user adds new account numbers to the spreadsheet after it is created. Essentially the same thing as right clicking on a column in Excel, select "Format Cells" and then selecting Text from the Categories list. I cannot find anywhere in the documentation or examples that will allow me to do this.

Thanks

[Yavanaarasi G]

Hi Todd,

Thank you for your interest in Syncfusion products.

You can format the cell as text by using NumberFormat. For leading Zeros you have to set the format as "00#". Please refer the below code snippet:

[C#]
sheet.Range["A1"].Number  = 0001;
sheet.Range["A1"].NumberFormat = "00#";

Here is the sample for your reference:
http://websamples.syncfusion.com//samples/XlsIO.Windows/XlsIO_Cell_format/main.htm

Please try this and let me know if this helps.

Regards,
G.Yavana

[JUAN CASTILLO]

ok