Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Mail Merge
In my merge the cents are not coming through from Excel if they are zeros. I
have formatted Excel to use currency with two decimal places. If the number is whole the merge does not bring over the two zeros and I need them. Can anyone help me out? I have fixed this problem in the past and cannot remember how. Thanks, Michele |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Mail Merge
Hi Michele,
In Word, add a numeric picture switch to the mergefield. To do this: .. select the field; .. press Ctrl-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; .. edit the field so that you get {MERGEFIELD MyData \# $,0.00}; .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: If you don't want the thousands separator (eg $1,000.00), delete the ',' in '$,0.00' from the formatting switch. -- Cheers macropod [MVP - Microsoft Word] "Michele" Michele @discussions.microsoft.com wrote in message ... In my merge the cents are not coming through from Excel if they are zeros. I have formatted Excel to use currency with two decimal places. If the number is whole the merge does not bring over the two zeros and I need them. Can anyone help me out? I have fixed this problem in the past and cannot remember how. Thanks, Michele |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge formatting | Microsoft Word Help | |||
Formatting in Mail Merge | Mailmerge | |||
Formatting in Mail Merge | Mailmerge | |||
Mail Merge fields merge with different formatting | Microsoft Word Help | |||
Zip+4 formatting in mail merge | Mailmerge |