View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail Merge Word 2003

You probably need to use a "numeric formatting switch" in your Word Mail
Merge Main Document.

For example, if the amount column in your Excel sheet is called "myamount"
then your Mail Merge Main Document may have a field like

{ MERGEFIELD myamount }

(Use Alt-F9 to show the "field codes")

You probably need to change that to

{ MERGEFIELD myamount \#"0.00" }

Peter Jamieson

"KentGSr" wrote in message
...
I have created a mail merge from an Excel file and all is fine except that
one field is an "amount" which is in the Excel data base as having two
digits
after the decimal point. When I merge, I get four digits after the
decimal.
I have reformated the Excel calculation and formatted again to have two
digits, and it still comes out as four.

Anyone have an idea how to fix this?