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.

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

Jim wrote:

> 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.