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

From SmartWiki
Jump to: navigation, search
 
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.
 +
 +
For example, 123456.789
 +
:{| border="1"
 +
|+
 +
|'''Number Format'''||'''Display'''
 +
|+
 +
|Currency||$20,000.00|+
 +
|#.##||123456.79
 +
|+
 +
|#.00||123456.79
 +
|+
 +
|0,000,###.0||123,456.8
 +
|+
 +
|Currency-GBP||
 +
|}
 +
  
  

Revision as of 12:40, 24 August 2009

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.

For example, 123456.789

Number Format Display
Currency + #.## 123456.79
#.00 123456.79
0,000,###.0 123,456.8
Currency-GBP


You can enter the word "Currency" to format as: $20,000.00