Free Support Forum - aspose.com

Set currency for cell

hi

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

kumar.

Hi,


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:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/setting-display-formats-of-numbers-dates.html
Otherwise, you need to use your desired custom string formatting value.

Thank you.