Difference between revisions of "Custom Field Type: Text Box - Number"
From SmartWiki
Line 16: | Line 16: | ||
|+ | |+ | ||
|Currency||2000000||$20,000.00 | |Currency||2000000||$20,000.00 | ||
+ | |+ | ||
+ | |Currency-QAR||2000000|| QAR 20.000,00 | ||
+ | |+ | ||
+ | |Currency-EUR||2000000|| €20,000.00 | ||
+ | |+ | ||
+ | |Currency-GBP||2000000|| £20,000.00 | ||
|} | |} | ||
+ | |||
+ | * Any currency defined by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217] can be shown by using the appropriate 3 letter currency code. | ||
+ | |||
+ | * This setting only applies in view mode, or when the values are displayed in a [[Web Page View]], [[Report]], [[MS Word Merge]], etc. No formatting is applied in edit mode. | ||
+ | : ''Note: 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:45, 2 October 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).
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-QAR 2000000 QAR 20.000,00 Currency-EUR 2000000 €20,000.00 Currency-GBP 2000000 £20,000.00
- Any currency defined by ISO 4217 can be shown by using the appropriate 3 letter currency code.
- This setting only applies in view mode, or when the values are displayed in a Web Page View, Report, MS Word Merge, etc. No formatting is applied in edit mode.
- Note: in edit mode you must use a period (.) as the decimal, even if the currency defined uses a comma (,).