Difference between revisions of "Custom Field Type: Text Box - Number"

Revision as of 12:55, 24 August 2009

The Number Format setting on Custom Fields 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).

@@ Line 1: / Line 1: @@
 The '''Number Format''' setting on [[Custom Fields]] 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.
+* '''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).
-For example, 123456.789
-:{| border="1"
-|+
+:{| border="1" cellpadding="5"
-|'''Number Format'''||'''Display'''
 |+
-|Currency||$20,000.00|+
+!Number Format!!Value!!Display
-|#.##||123456.79
 |+
-|#.00||123456.79
+|#,###.##||1234.5||1,234.5
 |+
-|0,000,###.0||123,456.8
+|#,###.00||1234.5||1,234.50
 |+
-|Currency-GBP||
+|Currency||2000000||$20,000.00
 |}
-You can enter the word "Currency" to format as: ''$20,000.00''
 [[Category:Custom Fields]]