Not able to apply currency format

pankajgrwl123 · February 19, 2021, 2:51pm

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”

ahsaniqbalsidiqui · February 19, 2021, 3:44pm

@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.

johnson.shi · February 20, 2021, 1:44am

Please try

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

instead.

pankajgrwl123 · February 23, 2021, 2:01pm

Thank you, It works.

amjad.sahi · February 23, 2021, 4:03pm

@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.