Currency format

  1. Select Currency from the list. This will prefix the number with the currency symbol.

  2. In the Decimal Places box, specify the precision of the number. You can have a minimum of 0 and a maximum of 15.

  3. Select the Thousands with Commas checkbox for comma formatted numbers i.e. $1,345,622 rather than $1345622.

  4. Select the Negatives in Brackets checkbox to enclose negative numbers in brackets i.e. ($123456) rather than -$123456.

  5. Select the Negative in Red checkbox to display negative numbers in red font.

Note: The currency symbol used by Ability is taken from the Regional settings in the Windows Control Panel.

See:

Number formats in database

Width properties in numeric fields