Numbers don't merge right in Word 2010

[ll4u76]

I have my mail merge data coming from an excel speadsheet. When I merge the data, my number values do not come across formatted correctly. In Excel, they have the format structure "$111,111.00" but in Word the same number comes across as 111111.

I have tried DDE but still brings the numbers over unformatted.

Please assist.

 

[SkipVought]

hi,

Merge does not inherit formatting in the source data. You must modify the mergfield format.

Check HELP on mergefield formatting.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ll4u76]

Thanks Skip

 

[macropod]

To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
• select the field;
• press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
• edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.
Note1: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
. \# 0 for rounded whole numbers
. \# ,0 for rounded whole numbers with a thousands separator
. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
. \# $,0 for rounded whole dollars with a thousands separator
. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values
The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.
If you use a final ';' in the formatting switch with nothing following, (eg \# "$,0.00;($,0.00);") zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s.
Note2: If you use a decimal tab or right-aligned tab to align the values and insert a tab into the field code after the $ sign, you can have the values right-aligned.

Cheers
Paul Edstein
[MS MVP - Word]

 

[macropod]

Cross-posted (and answered) at:

http://www.vbaexpress.com/forum/showthread.php?t=42411

For cross-posting etiquette, please read:

http://www.excelguru.ca/content.php?184

Cheers
Paul Edstein
[MS MVP - Word]

 

[macropod]

Also cross-posted at:

http://www.msofficeforums.com/mail-merge/13165-numbers-dont-merge-right-word-2010-a.html

Cheers
Paul Edstein
[MS MVP - Word]