I have some data in Excel that I am mail merging to Word for some documents I am mailing out.

One of the columns is a dollar value. They are formatted as currency and show correctly in Excel (ie $57,327.63).

When I mail merge all the value to word, it is not carrying over the "$" or the Comma (shows as 57327.63). This makes it look pretty crappy printed out. Anyone know a fix?

I know I can put a "$" before the mail merge field.... I am NOT sure on how to get a comma in the correct location though ($57,000 OR $100,000).

Thanks!

11/12/2009 3:06:02 PM

Problem solved.

11/12/2009 11:09:06 PM

It would be helpful to post the solution, so if someone else runs into the same type of problem, it can be found via search.

11/13/2009 8:43:51 AM

Down Killer - I was posting from my phone last night so others would not spend time on something not needed any more. Here is a link to the site that has the answer.

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

11/13/2009 9:10:51 AM