Numbers and currencies
You can use a range of field types to enter and maintain numerical and financial data. To enter a numerical value, select the number or currency field and enter a value or edit an existing value. When you type numbers and currencies, the figures you enter might be converted to a different format for saving and display.
The different numerical field types are:
Calculated numbers are whole numbers that are derived from other field values, such as the sum of two other numbers. It is not possible to edit calculated numbers.
Counting numbers are used for whole numbers. You can only enter numbers and a period (.), used as a decimal point. On saving, a prefix and commas (,) can be added; for example, 1675 might become gm 1,675. Although you can enter a decimal point, the typed figure is rounded to the nearest whole number on saving. For example, typing 3.49 or 2.51 is always saved as 3.
Real Numbers are used for numbers that might have fractions. You can enter numbers, periods (as a decimal point), and the characters defined by your Windows™-defined regional number options (perhaps commas (,) to separate thousands). On saving, a prefix might be added and decimal places rounded. For example, 83.47 might become mL 83.5.
Currency is used for financial values. For the decimal point in a currency value, you use the character that is specified in the Windows regional currency options. On saving, the value might be rounded and a currency symbol added. For example, 4856.4872 might become $4856.49.
Note: Only numbers between -2147483648 and 2147483647 are accepted.