Custom Field Type: Text Box - Number
From SmartWiki
(Redirected from Number Format)
Contents
General Description
The Text Box - Number field allows you to define how numbers in the field will be displayed.
Field Illustrated
File:Placeholder.png
Text Box - Number, in Edit Mode (above)
FieldOptions
All common options:
General Settings
Permissions & Availability
Classic Options
For further information, please refer to Custom Fields – General Information.
Options listed below are specific to this particular field type.
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 applies in view mode, or when the values are displayed in a Web Page View, Report, MS Word Merge, List View, etc.
- Currency formatting will be applied when the record is in edit mode only if the setting "Apply Format in Edit Mode" is selected in the custom field settings.
- Any currency defined by ISO 4217 can be shown by using the appropriate three-letter currency code. For example, if Currency-JPY (for Japanese Yen) is entered into the Number Format setting, the entered value of 12 will be displayed as ￥12.
Important: in edit mode you must use a period (.) as the decimal, even if the currency defined uses a comma (,).
