Skip to main content
Conga Support

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 Setup > Personal Information) 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).

{{Points \# 00.00}} appears as 09.00.

#

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.

{{Cost \# $### }} appears as $15.

, (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.

{{= NetProfit \# $#,###,###}} appears as $2,456,800.

%, $, *, and so on

Includes the specified character in the result.

{{= NetProfit \# "##%"}} appears as 33%.

[positive value];[negative value]

Specifies different number formats for results with positive or negative values.

{{Sales95 \# "$#,##0.00;-$#,##0.00"}}
Positive values appear as $1,245.65.
Negative values appear as -$1,245.65.

Currency

Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol, and two decimal places

{{OPPORTUNITY_AMOUNT \# Currency}}

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, 4, or 5 if using Currency1, Currency2, Currency3, etc.)

{{OPPORTUNITY_AMOUNT \# Currency0}}

Number

Formats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol, and two decimal places.

{{OPPORTUNITY_AMOUNT \# Number}}

Number0

Formats the value according to the Salesforce Locale, including a digit grouping symbol, but excluding two decimal places and a currency symbol.


{{OPPORTUNITY_AMOUNT \# Number0}}

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.

{{OPPORTUNITY_PROBABILITY \# Percent}}

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

{{OPPORTUNITY_AMOUNT \# #,##0}}

5,280

{{OPPORTUNITY_AMOUNT \# $#,##0}}

$5,280

{{OPPORTUNITY_AMOUNT \# $#,##0.00}}

$5,280.25

{{OPPORTUNITY_AMOUNT \# Currency}}

$5,280.25

 

Now assume we are formatting the same field value as above, however, the Salesforce Locale is “German (Germany)”.

Example

Output

{{OPPORTUNITY_AMOUNT \#  #,##0}}

5.280

{{OPPORTUNITY_AMOUNT \#  “#,##0 €”}}

Note: The formatting code is enclosed in quotes because it contains spaces.

5.280 €

{{OPPORTUNITY_AMOUNT \#  #,##0.00}}

5.280,25

{{OPPORTUNITY_AMOUNT \# Currency}}

5.280,25 €