When a number field is defined on a template, you have the option to set a value format pattern for the field. You can either select from the list of commonly used patterns or enter custom patterns.
Number Formatting:
0 (zero) |
This digit placeholder displays insignificant zeros if a number has fewer digits than there are zeros in the format. |
# |
This digit placeholder follows the same rules as the 0 (zero). However, naturalForms does not display extra zeros when the number that you type has fewer digits on either side of the decimal than there are # symbols in the format. |
% |
The percentage symbol will display the number as a percentage by multiplying the number by 100. |
negative numbers |
If you wish to display a number differently if it is negative, you will need two sections of the format separated by a semi-colon. |
text |
Text can be added in the number format. This can include any text or to show symbols (for example: $, <, >, :). |
Examples:
To display |
As |
Use this code |
1234.59 |
1234.6 |
####.# |
8.9 |
8.900 |
#.000 |
.631 |
0.6 |
0.# |
12 |
12.0 |
#.0# |
12000 |
12,000 |
#,### |
5000 |
$5,000.00 |
$#,##0.00 |
.453 |
45.3% |
#0.0% |
453.23 -453.23 |
453.23 (453.23) |
#.00;(#.00) |
34.56 -34.56 |
$34.56 Profit $34.56 Loss |
$#.00 Profit;$#.00 Loss |
Note: To type one of the following currency symbols in a number format, press NUM LOCK and use the numeric keypad to type the ANSI code for the symbol.
To enter |
Press this code |
¢ |
ALT+0162 |
£ |
ALT+0163 |
¥ |
ALT+0165 |
€ |
ALT+0128 |
Comments