Formatting Mail Merge

[Michele]

In my merge the cents are not coming through from Excel if they are zeros. I
have formatted Excel to use currency with two decimal places. If the number
is whole the merge does not bring over the two zeros and I need them. Can
anyone help me out? I have fixed this problem in the past and cannot remember
how.

Thanks,
Michele

 

[macropod]

Hi Michele,

In Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Ctrl-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00};
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: If you don't want the thousands separator (eg $1,000.00), delete the ',' in '$,0.00' from the formatting switch.