How do I carry format into word using mail merge?

[Beau Logue]

I am trying to carry a dollar amount into word, it is in excel, and the cells
are formatted for currency. it appears as $1.50 in excel, but 1.5 once merge
it to excel.

 

[Bernard Liengme]

Common problem with simple solution. Have a look at these sites:
http://homepage.swissonline.ch/cindymeister/mergfaq.htm#NumFormat
http://office.microsoft.com/en-us/word/HA011164951033.aspx
http://homepage.hispeed.ch/cindymeister/MergFram.htm

best wishes