Adjusting the precision of numeric data

Use the following procedure to adjust the precision of numeric data in a column or field.

Right-click the column’s header or the field and choose Format data from the pop-up menu.
In the Precision field of the Format dialog, specify the precision that you want.Use the Precision field to specify the:
- Number of decimal places to display for numeric data
- Number of significant digits to display for hexadecimal data
Warning
Important
This value is ignored for fields that display other data types.
The number of decimal places that are displayed for numeric data is affected by the value in the Width field. A decimal value is rounded to accommodate the width of a field. Insignificant decimal values are truncated to show as much useful data as possible.
Information
In a numeric field that has a Width value of six spaces and a Precision value of five digits, the following example shows how numbers would be formatted:

Number
Format
123.45
123.45
.123456
.12346 (value is rounded)
12345.6
12345. (value is truncated)
123456.1
123456 (value is truncated)
1234567.
###### (value is too big for the width)
(Optional) Click Apply to view the changes to the field without exiting the dialog.
When finished, click OK.The view is now customized. When you close the view, MainView Explorer prompts you to save your changes. If you decline, the customizations will not be retained.

On this page