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. | The '''Number Format''' setting on [[Custom Fields]] allows you to define how numbers in the field will be displayed. | ||
− | |||
− | |||
Line 16: | Line 14: | ||
|+ | |+ | ||
|Currency||2000000||$20,000.00 | |Currency||2000000||$20,000.00 | ||
− | |||
− | |||
|+ | |+ | ||
|Currency-EUR||2000000|| €20,000.00 | |Currency-EUR||2000000|| €20,000.00 | ||
|+ | |+ | ||
|Currency-GBP||2000000|| £20,000.00 | |Currency-GBP||2000000|| £20,000.00 | ||
+ | |+ | ||
+ | |Currency-QAR||2000000|| QAR 20.000,00 | ||
|} | |} | ||
+ | |||
+ | ===Notes=== | ||
+ | * The '''Number Format''' setting only applies in view mode, or when the values are displayed in a [[Web Page View]], [[Report]], [[MS Word Merge]], [[List View]], etc. | ||
+ | * No formatting will be applied when the record is in '''edit'''. | ||
* Any currency defined by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217] can be shown by using the appropriate 3 letter currency code. | * Any currency defined by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217] can be shown by using the appropriate 3 letter currency code. | ||
− | + | '''Important''': in edit mode you must use a period (.) as the decimal, even if the currency defined uses a comma (,). | |
− | |||
[[Category:Custom Fields]] | [[Category:Custom Fields]] |
Revision as of 09:49, 2 October 2009
The Number Format setting on Custom Fields allows you to define how numbers in the field will be displayed.
Number Format Value Display #,###.## 1234.5 1,234.5 #,###.00 1234.5 1,234.50 #.00 1234.5 1234.50 Currency 2000000 $20,000.00 Currency-EUR 2000000 €20,000.00 Currency-GBP 2000000 £20,000.00 Currency-QAR 2000000 QAR 20.000,00
Notes
- The Number Format setting only applies in view mode, or when the values are displayed in a Web Page View, Report, MS Word Merge, List View, etc.
- No formatting will be applied when the record is in edit.
- Any currency defined by ISO 4217 can be shown by using the appropriate 3 letter currency code.
Important: in edit mode you must use a period (.) as the decimal, even if the currency defined uses a comma (,).