Format Number Values in Word
The number formatting picture switch begins with \#, followed by any combination of the
following parameters. Please see the examples following this table. When Conga Composer
populates a numeric value, the digit grouping symbol (the thousands separator) is defined
according to your Locale settings (as defined in Salesforce’s ) or according to the Culture or CurrencyCulture Conga Composer
parameters.
Despite the cultural settings that govern the output from Conga Composer, within an appearance parameter, you must use a comma (",") for the digit grouping symbol (for thousands) and a period (".") as the decimal symbol. You cannot swap the comma and period (American style) with a picture switch. If your goal is international currency behavior, please see Dynamic Currency Formats in Word.
|
Parameter |
Description |
|---|---|
|
0 (zero) |
Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a 0 (zero).
|
|
# |
Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, nothing appears in that place.
You can format phone number as well using this merge field |
|
, (digit grouping symbol) |
Separates a series of three digits. The digit grouping symbol is always entered as a comma into the formatting code, regardless of the country’s cultural preference. Conga Composer will format the output according to the cultural preference.
|
|
%, $, *, and so on |
Includes the specified character in the result.
|
|
[positive value];[negative value] |
Specifies different number formats for results with positive or negative values.
Negative numbers |
|
Currency |
Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol, and two decimal places
Positive values appear as $1,245.65. Negative values appear as ($1,245.65). |
| Currency0 Also available: Currency1, 2, 3, 4 |
Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol, and zero decimal places (or 1 decimal place, 2 decimal places, 3, or 4 if using Currency1, Currency2, Currency3, etc.) Currency decimal only works up to 4***
|
|
Number |
Formats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol, and two decimal places.
|
|
Number0, 1, 2, 3, 4 |
Formats the value according to the Salesforce Locale, including a digit grouping symbol, but excluding two decimal places and a currency symbol. (or with 1 decimal place, 2, 3 or 4)
Can also be used with SUM fields. |
|
Percent |
Formats the value according to the Salesforce Locale, by multiplying the value by 100 and including a digit grouping symbol, two decimal places, and a percent sign.
Cannot be used with SUM fields. |
Examples
Here are some common examples of the number appearance parameter. Assume that the field we are formatting is OPPORTUNITY_AMOUNT and that it contains 5280.25 and the Salesforce Locale is “English (United States)”.
|
Example |
Output |
|---|---|
|
|
5,280 |
|
|
$5,280 |
|
|
$5,280.25 |
|
|
$5,280.25 |
Now assume we are formatting the same field value as above, however, the Salesforce Locale is “German (Germany)”.
|
Example |
Output |
|---|---|
|
|
5.280 |
|
The formatting code is enclosed in quotes because it contains spaces. |
5.280 € |
|
|
5.280,25 |
|
|
5.280,25 € |
