Free Support Forum -

Set currency for cell


how to set the currency code for cell using builtin formating number with 4 decimals.

if i am using this one "$#,##0.0000_);[Red]($#,##0.0000)";

and after this i am changing the currency code using regional setting.

then the currency code for the cell doesnot change.

if i use the built in code it is working. but i need to display 4 digits with different currency codes.

thanks & regards



Well, there is no built-in formatting for currency values that has 4 decimal places. We recommend you to try to use “8” as number format value that does have 2 decimal places if it fits your requirement:
Otherwise, you need to use your desired custom string formatting value.

Thank you.