==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)!|Display (Example)|-!Display|None|+|123456.51|#,###|123456.##51|-!|Integer||1234123456.551||1123,234457|-!|Comma||123456.551||123,457|-!|Decimal|+|123456.51|#|123,###456.0051|-!|Currency (US Dollars) ||1234123456.551||1$123,234456.5051|+-!|#.00Percent (Decimal)||12340.55199||1234.5052%|+-!|Percent(Display Number)||51.1599||1552%|+-!|Custom||''Not Applicable''||''Not Applicable''|} {| class="wikitable"|-!|Number Precision!|Value (Example)!|IntegerDisplay (Example)|-!|Whole Number||121234.99951234||121234|+-!|One Decimal||121234.1234||121234.001|+-!|CurrencyTwo Decimals||200001234.1234||$20,0001234.0012|+-!|$###,###,###Three Decimals||200001234.1234||$20,000 (currency with no decimals)1234.123|+-!|Currency-EURFour Decimals||200001234.1234|| €20,0001234.001234|-!|+Nearest Ten||1234||1230|Currency-GBP!|Nearest Hundred|20000|1234| £20,000.00|1200|+-!|Currency-QARNearest Thousand||200001234|| 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. * 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'''.
==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]]