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