To format a numeric merge field, use the \# switches. For example, to display a currency field as "$125.23", the merge field should be defined as {MERGEFIELD myObject.myField \# $#,##0.00}.

To format a date merge field, use the \@ switches. For example, to display a date field as "03/30/2010", the merge field should be defined as { MERGEFIELD myObject.myField \@ MM/dd/yyyy}.

To generate billing documents with specific currency symbols, you must create separate billing document templates for each currency and include the MERGEFORMAT using examples described in the following table. See How do I handle Multi-currency in Zuora for more information.

Date and Numeric Format Examples

The following table includes formatting examples for the date and number types mail merge fields.