Formatting numbers in MM

[Cheri]

I cannot get my numbers from Excel to merge correctly into my letter. Some
of the numbers have .00000000. I searched and tried to do the
tools/options/general, "confirm file conversion at opening" but did not have
that option. Tried different formats - what can I do to get amounts that are
$xxx.xx into my letter

 

[macropod]

Hi Cheri,

You need to add a formatting switch to the mergefield. To do this:
.. Select the mergefield and press Shift-F9. You should see something like '{MEZRGEfIELD Amount}'
.. Add a numeric picture switch to the end of the mergefield, thus: '{MEZRGEfIELD Amount \# $,0.00}'
.. Press F9 to update the field
.. Run your mailmerge

 

[Cheri]

Macropod -
Works like a champ - how would I have known that? Lame duck that I am?

Hi Cheri,

You need to add a formatting switch to the mergefield. To do this:
.. Select the mergefield and press Shift-F9. You should see something like '{MEZRGEfIELD Amount}'
.. Add a numeric picture switch to the end of the mergefield, thus: '{MEZRGEfIELD Amount \# $,0.00}'
.. Press F9 to update the field
.. Run your mailmerge

--
Cheers
macropod
[MVP - Microsoft Word]

I cannot get my numbers from Excel to merge correctly into my letter. Some
of the numbers have .00000000. I searched and tried to do the
tools/options/general, "confirm file conversion at opening" but did not have
that option. Tried different formats - what can I do to get amounts that are
$xxx.xx into my letter