We're trying to merge in currency fields from excel, the cells are set up to
display $0,000.00  when actually the value could be $0,000.00000000  as seen
in the formula bar.  When merged into word that's what we get 0,000.0000000
when we only want $0,000.00.  Help says that the data source format doesn't
matter to Word and will be able to modify the format to display the data how
ever we choose...but when we "edit field" NumChars...and select
$#,##0.00;($#,##0.00) our number changes to $5.00....

tia for any help or comments...