| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When I merge excel with word I lose the currency digit ex $18.4
I set the currency and the decimal to 2 but when I merge into word I get a
loss of the last digit if it is zero |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
When I merge excel with word I lose the currency digit ex $18.4
Use Alt-F9 to display your field codes.
Find the one you need to change. It will probably look like { MERGEFIELD mynumber } or { MERGEFIELD mynumber \*Mergeformat } Remove any \*Mergeformat and type \#0.00 so that you have { MERGEFIELD mynumber \#0.00 } Use Alt-F9 to display field results. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Johnnylaw wrote: I set the currency and the decimal to 2 but when I merge into word I get a loss of the last digit if it is zero |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
When I merge excel with word I lose the currency digit ex $18.4
Sorry, ignore the other message.
Use Alt-F9 to display your field codes. Find the one you need to change. It will probably look like { MERGEFIELD mynumber } or { MERGEFIELD mynumber \*Mergeformat } Remove any \*Mergeformat and type \#$0.00 so that you have { MERGEFIELD mynumber \#$0.00 } Or if your outputt needs to have thousands separators, use { MERGEFIELD mynumber \#$,0.00 } Use Alt-F9 to display field results. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Johnnylaw wrote: I set the currency and the decimal to 2 but when I merge into word I get a loss of the last digit if it is zero |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
When I merge excel with word I lose the currency digit ex $18
Thanks!!! I figured it out with your help!!
"Peter Jamieson" wrote: Sorry, ignore the other message. Use Alt-F9 to display your field codes. Find the one you need to change. It will probably look like { MERGEFIELD mynumber } or { MERGEFIELD mynumber \*Mergeformat } Remove any \*Mergeformat and type \#$0.00 so that you have { MERGEFIELD mynumber \#$0.00 } Or if your outputt needs to have thousands separators, use { MERGEFIELD mynumber \#$,0.00 } Use Alt-F9 to display field results. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Johnnylaw wrote: I set the currency and the decimal to 2 but when I merge into word I get a loss of the last digit if it is zero |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value | Mailmerge | |||
| Currency format is lost during Document Merge from Excel to Word. | Mailmerge | |||
| merge currency incl .00 from excel into word doc | Mailmerge | |||
| Currency format - Excel to Word Merge | Microsoft Word Help | |||
| Currency fields in Access lose th currency format whn merged why | Mailmerge | |||
Linear Mode
