Currency Format

Use the CurrencyObject to determine how this ValueFormat appears. The Currency format puts a dollar sign in front of the value, pads the value with zeros (2 is the default) for the cents. The default format code is:

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

·      Use the OrderCurrencySignValue property to change the order of the negative sign, dollar sign, and value.

·      Use the NegativeValueColor property to specify the color used to display negative values.