Custom Field Type: Text Box - Number

From SmartWiki
Revision as of 09:45, 2 October 2009 by Cameron (talk | contribs)

Jump to: navigation, search

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 (,).