Free Support Forum - aspose.com

Not able to apply currency format

Hi team,

When I am applying the currency format with 3 Character not able to apply getting attached error

It works with $ and other currency but not working with CHF and other of this category.

style.Custom = “CHF#,##0.00”

image.png (5.5 KB)

@pankajgrwl123,
Could you please share your sample Excel file created by MS Excel as I am not able to set this style manually in MS Excel. We will analyze your template Excel file and share our feedback accordingly.

Please try

            style.Custom = "\"CHF\"#,##0.00";

instead.

Thank you, It works.

@pankajgrwl123,

Good to know that it works for your needs. Feel free to contact any time if you need further help or have some other issue or queries, we will be happy to assist you soon.