Losing $ and , in numbers being merged from Excel into Word docume

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FlorencePS - 11 Nov 2005 20:15 GMT

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?

Reply to this Message

Graham Mayor - 12 Nov 2005 07:07 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

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

Reply to this Message