The Format dialog helps you to format the selected Numeric field.

You can access this dialog by clicking Format Help in the Column Editor dialog (for Browse).

The Format dialog for Numeric field includes the following options:

Number Format Enter a valid display format for the selected numeric field (->,>>>,>>9 is the default).
Total Number of Digits Enter the total number of digits allowed for the selected field (7 is the default).
Number of Decimal Places Enter the number of decimal places to the right of the decimal character to display for the field value.
Use Thousand's Separator Select to display a comma (,) as the thousands separator character for the field value (default).
Suppress Leading Zeros Select to suppress any leading zeros in the field value.
Show as Zero Select to display zero values in the field as blank.
Show as Asterisk Select to display an asterisk (*) as the leading sign for the field value.
Leading Text String Enter a text string to display before the number, such as a currency sign.
Trailing Text String Enter a text string to display after the number, such as a currency sign.
Show Leading Sign Always Select to display all values with a leading sign.
Show Leading Sign on Negative Only Select to display only negative values with the leading sign (default).
Show Trailing Sign Always Select to display all values with a trailing sign.
Show Trailing Sign on Negative Only Select to display only negative values with the trailing sign.
Show Negative Numbers in Parentheses Select to display negative values between parentheses '()'.
Show Negatives With Trailing 'CR' Select to display negative values with the string "CR" after it.
Show Negatives With Trailing 'DB' Select to display negative values with the string "DB" after it.
Show Negatives With Trailing 'DR' Select to display negative values with the string "DR" after it.
Show Negatives With Trailing 'cr' Select to display negative values with the string "cr" after it.
Show Negatives With Trailing 'db' Select to display negative values with the string "db" after it.
Show Negatives With Trailing 'dr' Select to display negative values with the string "dr" after it.
Allow Positive Numbers Only Select to allow positive numbers only.
Standard Select to format the selected field to the default ABL format for numbers, which is: ->,>>>,>>9, 7 total digits, comma as thousands separator, and show leading sign on negatives only.