View Single Post
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default Losing $ and , in numbers being merged from Excel into Word docume

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?