Using Word & Excel 2003. When we try to merge data from Excel that has been
formatted as $1,500 it merges into the doc as 1500. We've tried everything,
from reformatting the cell back to General then reapplying Currency, and even
retyping that particular cell.

Any thoughts?

When merging with Office 2003, Word is now expected to provide the
formatting. You can do this with a formatting switch on the Word field - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


FlorencePS wrote:
Using Word & Excel 2003. When we try to merge data from Excel that
has been formatted as $1,500 it merges into the doc as 1500. We've
tried everything, from reformatting the cell back to General then
reapplying Currency, and even retyping that particular cell.

Any thoughts?