title: Apache POI : How to format numeric cell values
body: <p>I am using Apache POI 3.9 for XLS/XLSX file processing.</p>
  
  <p>In the XLS sheet, there is a column with numeric value like "3000053406".</p>
  
  <p>When I read it with POI with..</p>
  
  <pre><code>cell.getNumericCellValue()
  </code></pre>
  
  <p>It gives me value like "3.00E+08". This create huge problem in my application.</p>
  
  <p>How  can I set the number formatting while reading data in Apcahe POI ?</p>
  
  <p>There is a way that I know is to set the column as "text" type. But I want to know if there is any other way at Apache POI side while reading the data. OR can we format it by using simple java DecimalFormatter ? </p>