Using 1000 separators

[Mia A]

I selected the 1000-comma separator for my list in Excel. But when I merged the list into Word, the commas disappeared. is there any way to keep the commas when i merge to Word. or do I have to manually type in "1,200" in the cell in my Excel document?

Thanks to anyone who replies.
Mia

 

[Joe4]

Excel only sends the data to Word, not the formatting. You can format the field on Word's end. I don't know the specifics off the top of my head (on setting the formatting in Word), but I know it can be done.

Which version of Word are you using?

 

[Norie]

Mia

Are you using Word mail merge?

If you are then what you want to look at are switches.

Like jm14 I can't remember the specifics off the top of my head but I do remember the Word help files are actually quite helpful on the subject.

 

[Mia A]

Thank you both for your help!!
Mia