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.* '''Note''': This setting only applies in view mode (level 1) or when the data is being displayed (in a list view, web page view, report, etc). In edit mode no formatting will be applied.

==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 examplefurther information, 123456please refer to [[Custom Fields – General Information]].<br /><br />Options listed below are specific to this particular field type.789:===Number Format=== ----{| borderclass="1wikitable"|+-!|'''Number Format'''!|Value (Example)!|'''Display'''(Example)|-!|+None|Currency|123456.51||$20,000123456.0051|+-!|#Integer||123456.##51||123,457|-!|Comma||123456.7951|+|123,457|#-!|Decimal||123456.0051||123456123,456.7951|+-!|0,000,###Currency (US Dollars) ||123456.051||$123,456.851|-!|Percent (Decimal)||0.5199||52%|+-!|Percent (Display Number)||51.99||52%|Currency-GBP!|Custom||''Not Applicable''||''Not Applicable''

You can enter <!--[[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 word setting "CurrencyApply Format in Edit Mode" to format asis 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''$20(for Japanese Yen) is entered into the Number Format setting,000.00the 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]]