title: setCellType(HSSFCELL.CELL_TYPE_NUMERIC) is not working in apache poi
body: <p><code>SetCellType(HSSFCELL.CELL_TYPE_NUMERIC)</code> is not working in apache poi. 
  Anyone have used this feature of POI in JAVA?</p>
  
  <p>When I created XLS file using POI and cell contains integer value and I set cell type as numeric at that time that cell reflects some other integer value.
  Example:
  Using JAVA program and poi utility, I am putting in <code>Cell A1</code> value <code>"5"</code>. Now this cell contains Integer value but by default cell type is <code>CELL_TYPE_STRING</code>. So this cell gives me error and asked me to convert this cell to Number.
  But using program when I will set this cell type as <code>CELL_TYPE_NUMERIC</code> at that time it does not give me error in XLS file but it shows me <strong><em>different value</em></strong>. </p>
  
  <p>Anyone has faced such issue?
  If yes then is there any solution for this. I stuck up with this one.</p>
  
  <p>Please ask me if you need some more clarification.</p>
  
  <p>Thanks in advance.</p>