title: Converting into number format while writing from text file to excel in java
body: <p>We have one existing application where we read one text file and write into excel using java. Text file will have first row as header and subsequent rows as records which is fetched from database. 
  Currently while writing into excel, all the columns are getting converted into text format. We want to convert one column(consider column Z) as number.</p>
  
  <pre><code>String [] column = line.split("\\|~");
     for (int i = 0; i &lt; column.length; i++) {
                      Cell tmpCell =  row.createCell(i);
  
                      tmpCell.setCellValue(new HSSFRichTextString(column[i].trim()));
  
                  }
  </code></pre>
  
  <p>I am new to java, need your help in resolving this issue.</p>
  
  <p>Thanks
  Santhosh</p>