Changes

Jump to: navigation, search

Custom Field Type: Text Box - Number

65 bytes removed, 16:55, 24 August 2009
no edit summary
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 Level 1) or and when the data field is being displayed (in a list view, web page view, report, etc). In edit mode no formatting will be applied.
For example, 123456.789 :{| border="1"|+|'''Number Format'''||'''Display'''cellpadding="5"
|+
|Currency||$20,000.00|+|#.##||123456.79!Number Format!!Value!!Display
|+
|#,###.00##||1234561234.795||1,234.5
|+
|0,000#,###.000||1234.5||1231,456234.850
|+
|Currency-GBP||2000000||$20,000.00
|}
 
 
You can enter the word "Currency" to format as: ''$20,000.00''
[[Category:Custom Fields]]
0
edits

Navigation menu