w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
In Goolge Visualization number format when having negative money how can I have the minus sign before the dollar sign

The ISO patterns support specifying a negative number pattern so you can change the default handling of negative numbers. The negative pattern follows all the same rules as the positive pattern, but no negative sign is applied automatically, you must specify it as part of the pattern (this allows for using culture-specific negative patterns or task-specific negative patterns). In your case, the negative pattern would look like this:

"-$###,##0.00"

To combine the patterns, separate them with a ; in the pattern string: "<positive pattern>;<negative pattern>". Your pattern string would look like this:

"$###,##0.00;-$###,##0.00"




© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.