You can determine how numeric fields are displayed in your Views and printed in reports. The formatting is used only to display and print the numeric field and is not stored in the data file. For this reason, you can display and print the same field differently in different Views and reports.
Note: Unless all numeric fields are of one type (e.g., quantities or dollar values as opposed to identification numbers), you need to format fields individually by selecting Table Layout under the Edit menu.
Examples of Numeric Formatting
|
This Numeric Format Specification |
Formats This Number |
Like This |
|
-999,999,999.99 |
1234.55 |
1,234.55 |
|
-999,999,999.99CR |
-1234.55 |
1,234.55CR |
|
999,999,999.99- |
-1234.55 |
1,234.55- |
|
(999,999.99) |
-1234.55 |
(1,234.55) |
|
(999,999.99) |
1234.55 |
1,234.55 |
|
9999999.99 |
1234.55 |
1234.55 |
|
$9 999.99 |
9871234.55 |
$9871 234.55 (Note the absence of formatting for the three leftmost digits) |
|
$9,999,999.99 |
9871234.55 |
$9,871,234.55 |
The numeric format consists of three components: the negative indicator, punctuation and digits.
The negative indicator is the character that signifies a negative number. Analyzer recognizes a negative sign, parentheses or “CR” as valid indicators (and only these). The indicator can either lead or trail the digits.
If the negative indicator is omitted, a leading minus is added for negative numbers.
Punctuation includes the thousands separator (usually a comma), the decimal place character (usually a period) and any other punctuation such as % or $.
You can change these options by selecting Tools from the menu and choosing Options. Then click the [Numeric Options] tab and use the Decimal Place Symbol and Thousands Separator text boxes to specify how you want numeric data to be displayed.
You can use any other punctuation (such as a floating “$” or “%”), as required. There is no restriction on optional punctuation.
Digits are always represented by 9s. In Analyzer, 9s imply a blank fill, not a zero fill.
If you specify more digits than required, the extra digits and anything between them, such as commas, are removed.
If you do not specify enough digits in the numeric format, the extra digits in your data are added immediately to the left of the leftmost 9, with no additional punctuation.
Analyzer does not zero-fill numeric fields or provide any other kind of leading fill characters. All numeric fields are blank-filled from the left and any punctuation in front of the first digit is automatically floating.
By default, Analyzer displays all numbers using the basic format of “9999999.99”. For example, the number 12,458,211.62 is displayed as “12458211.62”.
To change the default representation:
| 1. | Select Tools from the menu and choose Options. |
| 2. | Select the [Numeric Options] tab. |
| 3. | Choose a format specification from the Default Numeric Format text box. |
You can also choose to create your own numeric format. Follow the examples listed in Examples of Numeric Formatting.