Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I limit decimal places in a merge document?
I am using an Excel file that contains a numeric field that has 2 decimal
places. When I use Word and mail/merge document feature, the decimal places are not limited to 2. How can I correct that? -- Thank you for your help. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I limit decimal places in a merge document?
Try
a. using Alt-F9 to reveal the field codes in your Word mail merge main document b. where you have { MERGEFIELD mynumber } or { MERGEFIELD mynumber \*Mergeformat } change it to { MERGEFIELD mynumber \#0.00 } Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Bill wrote: I am using an Excel file that contains a numeric field that has 2 decimal places. When I use Word and mail/merge document feature, the decimal places are not limited to 2. How can I correct that? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I limit decimal places in a merge document?
That worked. Thank you very much.
-- Thank you for your help. "Peter Jamieson" wrote: Try a. using Alt-F9 to reveal the field codes in your Word mail merge main document b. where you have { MERGEFIELD mynumber } or { MERGEFIELD mynumber \*Mergeformat } change it to { MERGEFIELD mynumber \#0.00 } Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Bill wrote: I am using an Excel file that contains a numeric field that has 2 decimal places. When I use Word and mail/merge document feature, the decimal places are not limited to 2. How can I correct that? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do You Limit Decimal Places In Mailmerge Value From Excel? | Mailmerge | |||
mail merge with excel - how do get only 2 decimal places after com | Mailmerge | |||
Limit the number of decimal places shown when I merge Excel-Word | Mailmerge | |||
Unwanted decimal places in a mail merge from Excel | Mailmerge | |||
Limit decimal places in mail merge document | Mailmerge |