title: How to get the formatted value of a number for a cell in Apache POI?
body: <p>I wanted to get the value of a Numeric cell as a simple string.</p>
  
  <p>Suppose there the type of cell is numeric with value <code>90%</code>.
  Now I cannot use <code>cell.getStringCellValue()</code> as it will throw exception.
  I also cannot use <code>cell.getNumericCellValue()</code> as it will return me <code>.9</code> and not <code>90%</code>.</p>
  
  <p>I want to store in db which is of type varchar2, so I want the value in string only.</p>
  
  <p>I cannot change the cell type in <code>xls</code> as its the end user job, I have to handle this in code itself.</p>
  
  <p>Also formatter does't work well as there could be different cell types in the xls...dd:mm,dd:mm:ss,formula etc.</p>
  
  <p>All I want is that whatever the cell type is I need to get its value as simple String.</p>