If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|