Changes

Custom Field Type: Text Box - Number

1,519 bytes added, 23:21, 21 November 2018

no edit summary

==General Description==The '''Text Box - Number Format''' setting on [[Custom Fields]]  field allows you to define how numbers in the field will be displayed.

==Field Illustrated==

[[Image:placeholder.png]]<br />

''Text Box - Number, in Edit Mode (above)''

==FieldOptions==All common options:<br />[[Custom Fields - General Information #General_Settings|General Settings]]<br />[[Custom Fields - General Information #Role Field Permissions and Status Field Permissions|Permissions & Availability]]<br />[[Custom Fields - General Information #Classic Options|Classic Options]]<br />For further information, please refer to [[Custom Fields – General Information]].<br /><br />Options listed below are specific to this particular field type. ===Number Format=== ----{| borderclass="1" cellpadding="5wikitable"|+-!|Number Format!|Value (Example)!Value|Display (Example)|-!|None||123456.51||123456.51|-!Display|Integer|+|123456.51|#|123,###457|-!|Comma||123456.##51||123,457|-!|Decimal||1234123456.551||1123,234456.551|+-!|#Currency (US Dollars) ||123456.51||$123,###456.0051|-!|Percent (Decimal)||12340.55199||52%|-!|Percent (Display Number)||1,23451.5099||52%|-!|Custom||''Not Applicable''|+|''Not Applicable''|#} {| class="wikitable"|-!|Number Precision!|Value (Example)!|Display (Example)|-!|Whole Number||1234.001234||1234|-!|One Decimal||1234.51234||1234.501|+-!|CurrencyTwo Decimals||1234.1234||1234.12|-!|2000000Three Decimals||$20,0001234.001234|+|1234.123|Currency-EUR!|Four Decimals|2000000|1234.1234| €20,000|1234.001234|+-!|Nearest Ten||1234||1230|Currency-GBP!|Nearest Hundred||20000001234|| £20,000.001200|+-!|Currency-QARNearest Thousand||20000001234|| QAR 20.000,001000

|}

[[Category:Custom Fields]]

[[Category:Custom Field Types]]

<!--[[Image:PrecisionSetting.png|link=]]

[[Image:NewNumberFormatting.png|link=]]-->

===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. * Formatting Currency formatting will be applied when the record is in [[edit mode]] only if the setting "Show Currency Apply Format in Edit Mode" is selected in the custom field settings. * Any currency defined by [http://en.wikipedia.org/wiki/ISO_4217 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]]

[[Category:Custom Fields]][[Category:Currency]][[Category:How]]

• ← Older edit

Nancy Sabo

Smartstaff, administrator

421

edits