The number formatting parameter begins with \#, followed by any combination of the following parameters. 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 Setup > Personal Information) or according to the Culture or CurrencyCulture Conga Composer parameter.

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.

List of Parameters

PARAMETERDESCRIPTION
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, Word displays a space.
, (digit grouping symbol)Separates a series of three digits.

Note: 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 the cultural preference.

%, $, *, and so onIncludes the specified character in the result.
"positive; negative"Specifies different number formats for positive and negative results.
CurrencyFormats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol (“thousands separator”) and two decimal places

Example:

{{OPPORTUNITY_AMOUNT \# Currency}}

Currency0Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol (“thousands separator”) and zero decimal places

Example:

{{OPPORTUNITY_AMOUNT \# Currency0}}

In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter.

NumberFormats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol (“thousands separator”) and two decimal places

Example:

{{OPPORTUNITY_AMOUNT \# Number}}

Number0Formats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol (“thousands separator”) and zero decimal places

Example:

{{OPPORTUNITY_AMOUNT \# Number0}}

PercentFormats the value according to the Salesforce Locale, by multiplying the value by 100 and including a digit grouping symbol (“thousands separator”), two decimal places and a percent sign.

Example:

{{OPPORTUNITY_PROBABILITY \# Percent}}

In Conga Composer solutions, you can override the Salesforce Locale with the CurrencyCulture or Culture parameter.