Dynamic Currency Formats in Word
You can format currency values based on a value stored in a Salesforce field.
To format currency values based on a Salesforce field:
- On a Salesforce object, create a picklist field and populate it with culture code values. For a list of available culture codes, see Supported Culture Codes.
- In the Conga Composer button URL, insert the CurrencyCulture parameter and the related object and field in the following format:
&CurrencyCulture={!Object.Field}
Example: For an Opportunity object containing a field named Culture:&CurrencyCulture={!Opportunity.Culture_c}
- Format the currency fields in your template using the "\# Currency" picture switch.
Example Merge Field: { MERGEFIELD Opportunity_LineItem_SalesPrice \# Currency}
Disable Wrap Text in cells that use Currency formatting to keep the value and the symbol on the same line. Navigate to Table → Table Properties → Cell → Optionsand clear the Wrap Text check box.