title: How to set currency type to a column in POI
body: <p>How do I convert  a  column to  currency  type in  XSSFWorkbook using  poi in java ?</p>
  
  <p>Here is the code I  have used :</p>
  
  <pre><code>DataFormat datafrmt = wbAll.createDataFormat();
  cellStyle.setDataFormat(datafrmt.getFormat("$#,##0.00")); 
  </code></pre>
  
  <p>But after setting the data format I tried opening the Excel sheet and checked the format of the column it shows custom type but I need the column to be a currency  type. How  can I  achieve this?</p>