Donation amount merge field has commas in it
The merge field for donation amount prints a number with no commas. This is hard to read with large numbers. It would be good to have commas in the donation amount merge field.
Anonymous
shared this idea
-
This can be handled by the template as it is a Word document.
Follow these steps to format a number.
1. On the Word menu (assuming Word 2013 for this with the ribbon), select the Insert option.
2. Find the drop-down next to "Quick Parts". Click it and select "Field..."
3. Scroll down on the left side and select "MergeField"
4. On the right side of the box, enter the name of the field you want to use. (In this case, donation_amount) and click the OK button.You now need to be in View Field Codes mode of Word. If what you just entered looks like <<donation_amount>>, hold down the ALT key and press F9. That will turn on display field codes. It should look like
{ MERGEFIELD donation_amount \* MERGEFORMAT }Now we want to set the format. Since it is a numeric field, change the * symbol (where it has \* MERGEFORMAT) to a # symbol so it reads \# MERGEFORMAT }. Now you need to replace the word "MERGEFORMAT" with the actual format you want to use. To see possible formats, go into Excel and choose Format cells and the custom. That is the format used here.
Some common ones would be
"$#,###.00" for currency format
"#,####.00" for numeric without the currency symbol
"#,###" for the whole number value with commasSo in this case, change MERGEFORMAT to "#,###.00" (including the quotation marks) so your area should now look like
{ MERGEFIELD donation_amount \# "#,###.00" }
Note that you can not just type that in, you have to use the insert quick parts or CommunitySuite will just print out exactly what you entered.
So follow those steps anytime you want to change a format for any numeric field.
Feel free to reach out to me directly or our tech support team for further assistance.
