Format Number Dialog Box

To accommodate companies located or doing business in countries other than the United States, Vision provides default non-currency number formats for reports and other Vision output based on your settings in Regional and Language Options in Microsoft Windows.

In certain cases, Vision provides the Format Number dialog box so you can modify those default non-currency number formats to meet special requirements.

In Reporting, you can modify the default number formats for individual reports and for individual report columns. The Layout tab on the Options dialog box displays the default number (non-currency) format for the report. That format, in turn, becomes the default format for each numeric field on the report. You can modify the default format on the Layout tab, and you can modify the format for individual columns on the Columns tab. In either case, you change the settings on the Format Number dialog box.

To review or change your settings for Windows, display the Windows Control Panel and double-click Regional and Language Options.

Location

To display the dialog box, complete the following steps:

1. From the Vision Navigation menu, click Reporting and click the type of report.
2. In the Reports grid, click the Options column for the report.
3. Click .
4. On the Options dialog box, select one of the following actions:

   Option	Description
   To change the format for the report	Click the Layout tab, and click in Number in the Default Formats group box. (For the Key Financial Metrics report, click the Metrics tab.)
   To change the format for an individual column	Click the Columns tab, click the Format grid column for the report column, and then  click .

Contents

Field	Description
Type	Indicate if you want the format to be a number or a percentage. If you select Percent, Vision adds a percent sign (%) to each number.
Sample	This field displays the formats for positive numbers, negative numbers, and zero. As you select formatting options, Vision updates these samples based on your selections.
Use default number of decimal places	Select this option to use the default number of decimal places. To use a different number of decimal places, clear that check box and specify the number of decimal places in Decimal places. (Note that in some cases, Vision uses a fixed number of decimal places for a report column. If you specify a different number, it has no effect on those columns.)
Decimal places	If you do not select Use default number of decimal places, select or enter the number of decimal places in Decimal places. (Note that in some cases, Vision uses a fixed number of decimal places for a report column. If you specify a different number, it has no effect on those columns.)
Digit grouping	Select from the following digital grouping options: 123456789 — Vision does not group digits. Default grouping — Vision groups digits using the default grouping for the applicable culture. For example, if the culture for the report displayed in the Override regional settings field on the Layout tab is English (United States), this option is 123,456,789.
Negative number	Specify how you want to indicate negative numbers: Sign on front — Vision displays a minus sign before the number. Sign on back — Vision displays a minus sign after the number. Parentheses — Vision displays the number within parentheses.
Zero number	Specify how you want to indicate zero values: display 0, display a short dash (-), or leave the space blank 0 — Vision displays 0. - — Vision displays a short dash. Do not display —Vision leaves the space blank.
OK	Click this button to close the Format Number dialog box and apply the formatting options.
Cancel	Click this button to close the Format Number dialog box and discard any changes you made to the formatting options.
Help	Click this button to display a help topic for the Format Number dialog box.