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.
--
Cheers
macropod
[MVP - Microsoft Word]
"Michele" <Michele [ at ]discussions.microsoft.com> wrote in message news:047EB309-5181-4BF2-B02A-AC64881FAD59[ at ]microsoft.com...
[Quoted Text] > 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
|