Changes

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

==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=== ----{| border="1" cellpaddingclass="5wikitable"|+-!|Number Format!!|Value(Example)!|Display (Example)|-!Display|None|+|123456.51|#,###|123456.##51|-!|Integer||1234123456.551||1123,234457|-!|Comma||123456.551||123,457|+-!|#,###.00Decimal||1234123456.551||1123,234456.5051|-!|+Currency (US Dollars) |#|123456.0051||1234$123,456.551|-!|Percent (Decimal)||12340.505199|+|52%|-!|Percent(Display Number)||51.1599||1552%|+-!|Custom||''Not Applicable''||''Not Applicable''|} {| class="wikitable"|-!|Number Precision!|Value (Example)!|Display (Example)|-!|IntegerWhole Number||121234.99951234||121234|+-!|One Decimal||121234.1234||121234.001|+-!|Two Decimals|+|1234.1234|Currency|1234.12|-!|2000000Three Decimals||$20,0001234.001234|+|1234.123|Currency-EUR!|Four Decimals||20000001234.1234|| €20,0001234.001234|-!|Nearest Ten||1234|+|1230|Currency-GBP!|Nearest Hundred||20000001234|| £20,000.001200|+-!|Currency-QARNearest Thousand||20000001234|| QAR 20.000,001000

* 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'''.

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