Difference between revisions of "Custom Field Type: Text Box - Number"
From SmartWiki
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