View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge on word, amounts are reflected with 11 digits not 2

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

"TLB" wrote in message
...
Do you know any thing about the database server?

"macropod" wrote:

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Wilma" wrote in message
...