Mail merge Excel to Word

[Jim]

When I merge fields from Excel s/sheet into a Word document I loose the
formating. e.g if cell says $106.60 it merges as 106.6 or $320.00 merges as
320.
How can I merge so that the data retains the format.

 

[garfield-n-odie [MVP]]

Add a \# currency picture switch to the merge field in Word.
e.g.: { MERGEFIELD Amount \# }