How do you format a calculation resulting number when it is used in a mail merge field. $125.50 shows as $125.5 when the field is placed in a letter using mail merge. I cannot get the field to show the second 0 as $125.50. I can format the number field to show the 2 decimal places when it is used on layouts as the number field it is, but in the mail merge layout the <<mail merge>> field when selected only gives options for text formatting- the number option is grayed out. If I mail merge a number field that it not a calculation field, the second "0" shows but not when it is a number resulting from a calculation.
Book cost(number field) of $2.50 mail merges as $2.50
Total cost (calculation of book cost * 3) of $7.50 shows as $7.5
Version: v6.x
Platform: Windows XP
