Hi Farook,
//Instantiating a Workbook object
Workbook workbook = new Workbook(“D:/temp/book1.xlsx”);
//Obtaining the reference of the first (default) worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];
//Adding a new Style to the styles collection of the Excel object
int i = workbook.Styles.Add();
//Accessing the newly added Style to the Excel object
Style style = workbook.Styles[i];
//Number 49 denotes to the text style
style.Number = 49;
//Creating StyleFlag
StyleFlag styleFlag = new StyleFlag();
//Set NumberFormat to true
styleFlag.NumberFormat = true;
//Apply the style to the desired column
worksheet.Cells.Columns[1].ApplyStyle(style, styleFlag);
//Saving the Excel file
workbook.Save(“D:/temp/output.xlsx”);