I would need to have currency format for a cell as €4.000,00, I have tried everything but not working. The format I have tried as below.
- €#.###,##00 2. "€"#.##0,00 3. \€#.###,##00 4. \€#,##00.00
worksheet.getColumn('AK').style.numFmt = '"€"0.###,##00'
Can someone help me on this.