Difference between revisions of "Custom Field Type: Text Box - Number"

Revision as of 12:20, 1 September 2016

The Number Format setting on Custom Fields allows you to define how numbers in the field will be displayed.

Number Format	Value	Display
#,###.##	1234.5	1,234.5
#,###.00	1234.5	1,234.50
#.00	1234.5	1234.50
Percent	.15	15%
Integer	12.9995	12
Decimal	12	12.00
Currency	20000	$20,000.00
$###,###,###	20000	$20,000 (currency with no decimals)
Currency-EUR	20000	€20,000.00
Currency-GBP	20000	£20,000.00
Currency-QAR	20000	QAR 20.000,00
T##-#######	123456789	12-3456789 (EIN)
T### ### ###	123 456 789	123 456 789 (Canadian SIN)

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 "Show Currency 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 (,).

See Also

• Field Formatting Options
• Displaying a Number Value as Currency
• The Musings of Chin - Best Practice: Correct Data Formats

Click here to learn why this feature is a benefit to your organization.