title: Number stored as text warning in excel using POI
body: <p>I am getting <code>Number stored as text warning</code> for the created excel file using <strong>POI</strong>. I am trying to display percentage. This <a href="https://stackoverflow.com/questions/18939273/ho-can-i-remove-the-green-arrow-from-a-cell-on-excel-file-using-python-xlsxwrite">question</a> discusses the same, but it's for python. Can some one please suggest me how to avoid this in java using POI? </p>
  
  <p>Below are the lines where I get this warning.</p>
  
  <pre><code>workbook= new XSSFWorkbook();
  sh1 = wb.createSheet("Data Sheet");
      cell = row.createCell(3);
      cell.setCellValue(37 + "%");
  </code></pre>
  
  <p>Based on Gagravarr answer I did it this way.</p>
  
  <pre><code>XSSFDataFormat df = workbook.createDataFormat();
                      CellStyle cs = wb.createCellStyle();
                      cs.setDataFormat(df.getFormat("%"));
                      cell.setCellValue(0.37);
                      cell.setCellStyle(cs);
  </code></pre>
  
  <p>But it just shows up as 0.37 with no warning now, not 37%.</p>