Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Word 2003
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Word 2003
Peter, Thanks for your reply but I am left a little confused.
I tried Alt F9 in two places and found no way to add the # 0.00......should I change the column heading in my Excel data base to say "Amount/# 0.00" or should I do it somewhere else? I get the "amount" from the Excel file and it automatically loads it in to the mail merge letter as amount and I cannot seem to change that to amount /# 0.00, as I think you are suggesting. Any ideas?? Thanks for your help "Peter Jamieson" wrote: 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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Word 2003
In your Mail Merge Main Document, use Alt-F9 until you see something like
{ MERGEFIELD amount } or it may look like { MERGEFIELD amount \*Mergeformat } The stuff between the { } is just text, which yoiu can change on the keyboard. So if for example you see { MERGEFIELD amount } then you can click after "amount" and type \#"0.00" so you end up with { MERGEFIELD amount \#"0.00" } then click Alt-F9 and if necessary, select the field and press F9 to update the result. If "\*Mergeformat" is in there, it probably won't do any harm to delete it. Peter Jamieson "KentGSr" wrote in message ... Peter, Thanks for your reply but I am left a little confused. I tried Alt F9 in two places and found no way to add the # 0.00......should I change the column heading in my Excel data base to say "Amount/# 0.00" or should I do it somewhere else? I get the "amount" from the Excel file and it automatically loads it in to the mail merge letter as amount and I cannot seem to change that to amount /# 0.00, as I think you are suggesting. Any ideas?? Thanks for your help "Peter Jamieson" wrote: 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? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Word 2003
Dear Peter......IT WORKED.....you have been tremendously helpful....thank you
so much. "Peter Jamieson" wrote: In your Mail Merge Main Document, use Alt-F9 until you see something like { MERGEFIELD amount } or it may look like { MERGEFIELD amount \*Mergeformat } The stuff between the { } is just text, which yoiu can change on the keyboard. So if for example you see { MERGEFIELD amount } then you can click after "amount" and type \#"0.00" so you end up with { MERGEFIELD amount \#"0.00" } then click Alt-F9 and if necessary, select the field and press F9 to update the result. If "\*Mergeformat" is in there, it probably won't do any harm to delete it. Peter Jamieson "KentGSr" wrote in message ... Peter, Thanks for your reply but I am left a little confused. I tried Alt F9 in two places and found no way to add the # 0.00......should I change the column heading in my Excel data base to say "Amount/# 0.00" or should I do it somewhere else? I get the "amount" from the Excel file and it automatically loads it in to the mail merge letter as amount and I cannot seem to change that to amount /# 0.00, as I think you are suggesting. Any ideas?? Thanks for your help "Peter Jamieson" wrote: 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 pulls up my mail merge template, but doesn't complete the merge into a new Form Letter 1 | Mailmerge | |||
Automating Mail merge between Word 2003 and Access 2003 using VB.NET | Mailmerge | |||
Mail Merge Word 2003 Excel 2003 database | Mailmerge | |||
Word 2003 and Access 2003 Mail Merge question | Microsoft Word Help | |||
Exchange 2003 - Outlook 2003 - Word 2003 mail merge | Mailmerge |