mail merge on word, amounts are reflected with 11 digits not 2

M

macropod

Hi Wilma,

To fix this:
.. select the errant merge field
.. press Shift-F9 to expose the field code, which will look something like {MERGEFIELD Data}
.. add a numeric picture switch to the mergefield, thus:
{MERGEFIELD Data \# 0.00} for a plain number with two decimal places
or
{MERGEFIELD Data \# ,0.00} for a number with a thousands separator and two decimal places
or
{MERGEFIELD Data \# $0.00} for a dollars and cents
or
{MERGEFIELD Data \# $,0.00} for a dollars and cents with a thousands separator
.. press F9 to update the field
.. run your mailmerge

Cheers
 
T

TLB

Do you know any thing about the database server?

macropod said:
Hi Wilma,

To fix this:
.. select the errant merge field
.. press Shift-F9 to expose the field code, which will look something like {MERGEFIELD Data}
.. add a numeric picture switch to the mergefield, thus:
{MERGEFIELD Data \# 0.00} for a plain number with two decimal places
or
{MERGEFIELD Data \# ,0.00} for a number with a thousands separator and two decimal places
or
{MERGEFIELD Data \# $0.00} for a dollars and cents
or
{MERGEFIELD Data \# $,0.00} for a dollars and cents with a thousands separator
.. press F9 to update the field
.. run your mailmerge

Cheers
 
D

Doug Robbins - Word MVP

What do you want to know?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top