[CottonRLS]

I used to do this in Office 2003 for years, but for the first time this year,
I have to create a merge document in Word to pull Currency values from an
Excel 2007 worksheet range. No matter what I do, Word imports the currency
numbers to 4 decimal places. No change in Sheet versus named range, field
name changes, formatting Excel data differently (0 versus 2 decimal places),
or any other change I can think of gives me properly formatted currency
numbers.

I know there are merge codes to deal with this, but why should I have to
know all of these arcane formatting codes when it should be able to b e
handled automatically?

Thanks in advance.

CottonRLS