Commas drop off of number in mail merge to into Word

[glamisgrl]

Does anyone know why when I mail merge using Excel 2007 into Word why
the commas drop off of the numbers shown in my columns?

 

[Jim Thomlinson]

Check out this link...

http://www.gmayor.com/formatting_word_fields.htm

 

[glamisgrl]

Thank you. Forgive my ignorance but if this is my merge field
«Market_Value» what exactly would I add to it to keep the commas in place?

 

[Bruce Sinclair]

Thank you. Forgive my ignorance but if this is my merge field
«Market_Value» what exactly would I add to it to keep the commas in place?

Suggest you use the DDL option when getting the data. That fixed a number of
odd word formatting problems in an earlier xl/word version.

 

[Merrill, H.W. Barry]

Hope this is correct protocol to add my experience.
I use mail-merge to print ham radio certificates, and originally
imported a
tab-delimited .txt file, and the commas in the score were printed.
But I
found that mal-merge would simply stop printing after several hundred
when I used the tab-delimited file, so I imported that file into
excel,
and found all 2000 certificates were printed with no glitch, but then
discovered that, even though the comma is displayed in excel,
it is not printed by mail merge. So, I dropped back, use the
tab-delimited .txt file, and print 100 at a time and all is well,
no hangs, and the scores have commas.