General Description
The Text Box - Number field enables the specification of how numerical values within the field will be presented.
Field Options
Number Format
| Number Format | Value (Example) | Display (Example) |
|---|---|---|
| None | 123456.51 | 123456.51 |
| Integer | 123456.51 | 123,457 |
| Comma | 123456.51 | 123,457 |
| Decimal | 123456.51 | 123,456.51 |
| Currency (US Dollars) | 123456.51 | $123,456.51 |
| Percent (Decimal) | 0.5199 | 52% |
| Percent (Display Number) | 51.99 | 52% |
| Custom | Not Applicable | Not Applicable |
| Number Precision | Value (Example) | Display (Example) |
|---|---|---|
| Whole Number | 1234.1234 | 1234 |
| One Decimal | 1234.1234 | 1234.1 |
| Two Decimals | 1234.1234 | 1234.12 |
| Three Decimals | 1234.1234 | 1234.123 |
| Four Decimals | 1234.1234 | 1234.1234 |
| Nearest Ten | 1234 | 1230 |
| Nearest Hundred | 1234 | 1200 |
| Nearest Thousand | 1234 | 1000 |
Notes
- The Number Format setting is applicable in view mode, or when values are presented in a Web Page View, Report, MS Word Merge, List View, etc.
- Currency formatting will be applied during edit mode only if the "Apply Format in Edit Mode" option is selected in the custom field settings.
- Any currency defined by ISO 4217 can be displayed by utilizing the corresponding three-letter currency code. For instance, if Currency-JPY (for Japanese Yen) is specified in the Number Format setting, the entered value of 12 will be represented as ￥12.
Important: In edit mode, it is imperative to use a period (.) as the decimal separator, even when the currency defined utilizes a comma (,).