Accounting Format

Use the AccountingObject to determine how this ValueFormat appears. The Accounting format puts a dollar sign in front of the value, pads the value with zeros (2 is the default) for the cents, and pads the value with spaces so that the dollar signs and decimals are aligned. The default format code is:

_-$* #,##0.00;-$* #,##0.00

·      The underscore adds a space the size of a dash (-) to the beginning of the annotation, and the asterisk (*) adds space between the dollar sign and the value to make sure the dollar signs align correctly.

·      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.