We want to Excel result displays currency symbol like Romanian lei.
We’ve tried:
Style.setCutom(“lei #,##0.00”); or Style.setCutom("#,##0.00 lei");
But they are not workable.
What’s the correct way to set international currency symbols rather than $?
Thanks
Hi,
Please attach the xls/xlsx file with your desired currency symbol and number format. We will look into it and provide you a sample code to help you asap.
xls is attached
Hi,
Please use following code to get your desired result:
style.setCustom("#,##0.00" lei"");
Or
style.setCustom("#,##0.00 [$lei-418];-#,##0.00 [$lei-418]");
it works.
thanks