Nitobi Product Knowledgebase |
Number Masking Syntax 
You can use a format pattern to specify how a number column displays its data. The following characters can be used to define the pattern: - # (Denotes a digit [0-9])
- 0 (Denotes leading and trailing zeros)
- . (Specifies the position of the decimal place)
- , (Used as a group separator--e.g. ###,###)
- % (Formats the number as a percentage)
- ; (Pattern separator. The first pattern will be applied to positive numbers, the second to negative numbers)
Examples: - mask="#.00" value: 421 result: "421.00"
- mask="$###,###" value: 155463 result: "$155,463"
- mask="##%" value: 0.453 result: "45%"
Related ArticlesComments: |
 |
|
Knowledgebase
To be notified of new articles when they're available, subscribe to our RSS feed.
Support Resources
Take advantage of our knowledgebase of product tutorials and tips, and our support forums!
Sign up for our Newsletter:
Get industry articles and Nitobi company news in your
inbox every couple of months — here's a sample!
|
