How to Format Number or Currency Values in Conga (Word)

Formatting Number Values

The number formatting parameter 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 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. ​

 

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). Example: { = 4 + 5 \# 00.00 } displays "09.00".
#	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. Example: { = 9 + 6 \# $### } displays "$ 15".
, (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. ** Example: { = NetProfit \# $#,###,### } displays "$2,456,800".
%, $, *, and so on	Includes the specified character in the result. Example: { = NetProfit \# "##%" } displays "33%".
"positive; negative"	Specifies different number formats for positive and negative results. Example: If the bookmark Sales95 is a positive value, the field { Sales95 \# "$#,##0.00;-$#,##0.00" } displays the value with regular formatting— for example, "$1,245.65". A negative value is displayed with a minus sign— for example, "-$ 345.56".
Currency	Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol (“thousands separator”) and two decimal places Example: { MERGEFIELD OPPORTUNITY_AMOUNT \# Currency } In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter. ** Note: May be used with =SUM fields, in addition to merge fields **
Number	Formats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol (“thousands separator”) and two decimal places Example: { MERGEFIELD OPPORTUNITY_AMOUNT \# Number } In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter. ** Note: May be used with =SUM fields, in addition to merge fields **
Number Value In Words	Formats the value according to the Salesforce Locale, converts a number value into words. Example: {=VALUE /* DollarText} {=$94,000/ *DollarText} ​ninety-four thousand and 00/100
Percent	Formats 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: { MERGEFIELD OPPORTUNITY_PROBABILITY \# Percent } In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter. ** Note: Not for use with =SUM fields **

Example 1:
Here are several common examples of the number appearance parameter. Let’s say the field we’re formatting is OPPORTUNITY_AMOUNT and that it contains 5280.25 and the Salesforce Locale is “English (United States)”. ​
 

EXAMPLE	OUTPUT
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 }	5,280
{ MERGEFIELD OPPORTUNITY_AMOUNT \# $#,##0 }	$5,280
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0.00 }	5,280.25
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency }	$5,280.25
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number }	5,280.25

Example 2:
Let’s change the scenario a bit. Let’s assume we’re formatting the same field value as above, however, the Salesforce Locale is “German (Germany)”.
 ​

EXAMPLE	OUTPUT
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 }	5.280
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 € }	5.280 €
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0.00 }	5.280,25
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency }	5.280,25 €
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number }	5.280,25

Formatting a Currency Field

​Add a "picture switch" to the field.

​To do this: 

1. Right-click and choose "Toggle Field Codes"

​2. Remove "\*MERGEFORMAT", if it appears

3. Include a picture switch similar to "\# Currency" or "\# $#,##0"