Search code examples
exceljs

Currency format is excelJS

How do you format currency in exceljs?

All I've found is this from their docs...which I have no clue how to type so I pasted it, but it doesn't seem to work

// Set Column 3 to Currency Format 
ws.getColumn(3).numFmt = '�#,##0;[Red]-�#,##0';
Solution

  • Just took a little bit of tinkering with. 

    ws.getColumn(3).numFmt = '$#,##0.00;[Red]-$#,##0.00';

    The #'s are optional digits. If you don't care about negative numbers being red you can leave it as $#,##0.00