I can't tell your exact steps you are peforming. You may be able to solve
the problem by copying the data and using PasteSpecial choosing text. You
may want to copy the data first to a new worksheet using the paste special
method and then performing the mail merge from the new worksheet instead of
the origianl worksheet.

"DataGuy" wrote:

I hope this is a simple fix. I am merging some data from Excel into a form
built in Word.

I have fomated the cells in Excel but when the merge to Word they are not
coming out correctly.

EX - Number are formated in Excel with commas but merge to Word with no
commas and extend decimal places. Dates are formated in Excel as July 13,
2009 but merge to Word as 071309.

What do I need to do to get this merge to format properly in Word? Thanks
so much for your help.