Select the Add Currency Format command from the Formats menu. The Add Currency Format dialog, shown in the following image, is then displayed.
In the Format Name text box, specify a name for your currency format. You must enter 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 Positive Format combo box in the Format Options group box, select the required format you want to use for positive currency values. The default value is the positive format of your current Windows locale; for example, $10.50.
In the Negative Format combo box in the Format Options group box, select the required format you want to use for negative currency values. The default value is the negative format of your current Windows locale; for example, ($ 10.50).
In the Currency Symbol text box in the Format Options group box, specify the currency symbol that you want to use for the base locale of your current schema; for example, $. The default value is the currency symbol of your current Windows locale; for example, $ if your current locale is United States.
In the 1000’s Separator text box in the Format Options group box, specify the character you want to use to separate thousands. The default value is a comma character (,).
In the Decimal Point text box in the 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 of the Format Options group box, specify the number of digits you want to display 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 currency format. Alternatively, you can click the Next button to redisplay the Add Currency Format dialog so that you can enter another currency format or you can click the Cancel button to abandon your selections.
