Select the Add Numeric Format command from the Formats menu.
The Add Numeric Format dialog, shown in the following image, is then displayed.
In the Format Name text box, specify a name for your numeric format. You must specify a value in this text box. An exception is raised if the specified name does not start with an uppercase letter or the format name is not unique; that is, your schema already contains a format with that name.
In the Negative Format combo box in the Format Options group box, select the required format that you want to use for negative currency values. The default value is parentheses enclosing the number; for example, (10.50).
In the 1000’s Separator text box in the Format Options group box, specify the character you that want to use to separate thousands. The default value is a comma character (,).
In the Decimal Point text box in the Format Options group box, specify the character that you want to use to separate decimal digits from whole numbers. The default value is a period character (.).
In the Decimal Places text box in the Format Options group box, specify the number of digits that you want displayed to the right of the decimal separator. The default value is two decimal places; for example, 1,234.56.
If you do not want to show a leading zero in front of numbers less than 1 (for example, .75), uncheck the Show leading zero for decimals check box in the Format Options group box. Alternatively, if you want to show leading zeros for decimals (for example, 0.75) and the check box is unchecked, check the box.
The International - Number Format dialog from your Windows Control Panel determines the default setting of this check box; that is, if your workstation has the Windows Leading Zero option button selected, the Show leading zero for decimals check box is checked by default.
Click the OK button when you have defined your new numeric format. Alternatively, you can click the Next button to redisplay the Add Numeric Format dialog so that you can define another numeric format or you can click the Cancel button to abandon your selections.
