### Number tab

Use the Number tab (click Customize on the Number tab of the Format Editor) to set detailed formatting options for number fields in your report.

##### Use Accounting Format

When you select this option:

- the negative symbol used and its position is determined by the Windows Regional Settings (it will be either the minus sign or the brackets)
- the dash will be automatically chosen for "Show Zero Values as" (zero values are automatically displayed as dashes ('-') in your report
- the currency symbol is fixed on the left side.

##### Suppress if Zero

When you select this check box, nothing is printed in a column of number field data if it the value is zero.

##### Decimals

When you are setting up a custom format for a number field object, use this list to set the Decimals property for that object. This option allows you to specify the number of decimal places you want to print. You can specify from 0 to 10 decimal places. When you choose the number of decimal places you want, the program changes the sample number at the bottom of the dialog box to show you the results of your selection.

##### Rounding

When you are setting up a custom format for a number field object, use this list to set the Rounding property for that object. This property allows you to specify the number of places you want to round to. When you choose the number of places you want, the program changes the sample number at the bottom of the dialog box to show you the results of your selection.

##### Negatives

When you are setting up a custom format for a number field object, this property enables you to specify the way you want negative values to appear. Your options are:

-1.23 | Prints negative values with a leading minus sign (-100.00, -225.73, -1,000,000).
1.23- | Prints negative values with a trailing minus sign (100.00-, 225.73-, 1,000,000.00-).
(1.23) | Prints negative values in parentheses [ (100.00), (225.73), (1,000,000) ].

Set the Negatives property to fit your needs. The program changes the sample number at the bottom of the dialog box to reflect the property you choose.

##### Reverse Sign for Displaying

You can reverse the sign for debit and credit amounts in financial reports by selecting this check box.

##### Allow Field Clipping

The Allow Field Clipping check box determines whether overflow field representation is enabled for the selected field(s).

- Select this check box to disable overflow field representation. This means that if the value in the field is too large for the field, the value will be truncated. For example, if you have a field that is sized to allow 5 characters, and the value in the field is 3708.19, the field will print the value: 3708.1 (assuming that the field values are right-justified).
- Clear this check box to disallow field clipping and enable overflow field representation. With overflow field representation enabled, values that are too large for their fields will be represented by a string of # signs. For example, if you have a field that is sized to allow 5 characters, and the value in the field is 3708.19, the field will print: #####. This lets you know that the field needs to be resized (or that you need to select the Can Grow property).

##### Decimal separator

When you are setting up a custom format for a number field object, the Decimal box allows you to type in the character(s) you want to use as a decimal separator. The default is a decimal point (.). If you want to change the separator, replace the character in the edit box with the separator of your choice. The program modifies the sample number at the bottom of the dialog box as you type in your characters.

Note: The box does not expand as you type in your separation characters; you are limited to the number of characters the box will hold.

##### Thousands Separator

The Thousands separator property allows you to choose the way you want numbers over 999 to appear on your reports.

- When you select the property (check mark), the program inserts a comma (,) or another separator of your choice as a thousands separator character for amounts over 999. Your numbers are printed like this: 1,000.00, 10,000.00, 999,000.00.
- When you clear the property you deactivate the thousands separator character. Your numbers are printed like this: 1000.00, 10000.00, 999000.00.

##### Symbol

This box displays the current thousands separator. The default is a comma (,). If you would like to use a different thousands separator, type it in this box. The changes you make in this box do not apply unless you select the Thousands Separator check box.

##### Leading Zero

Leading Zero allows you to include a zero, if you wish, before the decimal point in decimal amounts less than one.

- Select this property if you want the program to include a zero before the decimal point whenever you have a decimal amount less than one (0.001, 0.9999, 0.755).
- Clear this property if you do not want the leading zero (.001, .999, .755).

##### Show Zero Values as

This list contains the options available for displaying values of zero (0) in the selected field.

###### Related topics

Format Editor

Formatting

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com