Changes

Custom Field Type: Text Box - Number

2,117 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.* '''Note''': No formatting will be applied when the record is in '''edit'''. * This setting only applies in view mode (Level 1) and when the field is being displayed (in a list view, web page view, report, etc).

==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.51|-!|Percent (Decimal)||0.5199||52%|-!|Percent (Display Number)||51.99||52%|-!|Custom||''Not Applicable''||''Not Applicable''|} {| class="wikitable"|-!|Number Precision!|Value (Example)!|Display (Example)|-!|Whole Number||1234.001234||1234|-!|One Decimal||1234.51234||1234.1,234|-!|Two Decimals||1234.1234||1234.5012|-!|Three Decimals|+|1234.1234|#|1234.00123|-!|Four Decimals||1234.51234||1234.501234|-!|Nearest Ten||1234||1230|-!|Nearest Hundred||1234||1200|+-!|CurrencyNearest Thousand||20000001234||$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 "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