Numeric Format Switch
- 2 minutes to read
Syntax
# [ “ ] switch-argument [ “ ]
A numeric switch-argument is like a numeric format string. If a switch-argument contains spaces, enclose it in quotation marks.
If the result type of a field is not numeric, this switch has no effect.
Specifiers
You can combine the following specifiers to construct a format string.
| Item | Usage |
|---|---|
| # | Specifies the numeric places to display in the result. If the result does not include a digit in that place, a space is displayed. |
| 0 (zero) | Specifies the numeric places to display in the result. If the result does not include a digit in that place, a 0 (zero) is displayed. |
| . (decimal point) | Determines the decimal point position. The actual decimal symbol is dependent on the local Culture. You can specify it in the Regional settings (Control Panel). |
| , (digit grouping symbol) | Separates a series of three digits. The actual symbol is dependent on the local Culture. You can specify it in the Regional settings (Control Panel). |
| x | Drops digits to the left of the “x” placeholder. If the placeholder is to the right of the decimal point, the result is rounded to that position. |
| - (minus sign) | Adds a minus sign to a negative result, or adds a space if the result is positive or 0 (zero). |
| + (plus sign) | Adds a plus sign to a positive result, a minus sign to a negative result, or a space if the result is 0 (zero). |
| other symbol(s) | Includes the specified character in the result. |
| ‘text’ | Adds text to the result. The text can contain any symbols, special symbols mentioned above are not interpreted. |
| “positive; negative; zero” | You can use combinations for displaying positive, negative and zero values differently - just use a semicolon between switch arguments. For example, { MERGEFIELD Amount # $#,##0.00;-$#,##0.00;$0 } displays positive values using $#,##0.00, negative values using -$#,##0.00, and zero values using $0. |