title: How to set Text format to a particular column in Excel using Aspose Cells
body: <p>I am using Aspose Cells and I need to convert a particular column to text format, as the column consists of both numbers and Text, by default the column is taken as number format. I have used</p>
  
  <pre><code> Aspose.Cells.Style style = worksheet.Cells["A3"].GetStyle();
   style.Number = 49;
   worksheet.Cells["A3"].SetStyle(style);
  </code></pre>
  
  <p>the above code works only for particular Cell but I need to Set Text format entire column, I have tried using this</p>
  
  <pre><code> Aspose.Cells.Style style = workbook.Styles[workbook.Styles.Add()];
   style.Number = 49; //Sets the Text format.
   StyleFlag flag = new StyleFlag();  
   worksheet.Cells.ApplyColumnStyle(0, style, flag); 
   worksheet.Cells.ApplyColumnStyle(1, style, flag);
  </code></pre>
  
  <p>the above code not working. Is there any other way to fix this? </p>
  
  <p>Thanks in Advance  </p>