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

[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

 

[TLB]

Do you know any thing about the database server?

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

 

[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