Print this page

I am running a mail merge and have found trailing zero's after the decimal in number fields are not included in the completed merge document. (e.g. 1.50 merges as 1.5).

Knowledge Article Number 000003766
Description

Trailing 0's in Number fields not included in a mered mail merge document.

Resolution

When you use mail merge from any object, only two decimal points are merged from Number fields, and trailing zero's are not included in the completed merge document. This is an expected behavior. Note: This applies only to Number fields; Currency fields are not affected and will show any trailing zero's after the decimal.

Example:

Salesforce Number field Value  123.20  This field will be merged as 123.2
Salesforce Number field Value  123.00  This field will be merged as 123
Salesforce Number field Value  123.12  This field will be merged as 123.12
Salesforce Number field Value  123.123 This field will be merged as 123.12





promote demote