Merge with Excel Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin D. - 02 Feb 2007 15:11 GMT

I'm doing a merge with data in an excel file to a Word letter. The Excel
file has 3 columns with numbers formatted as numbers with a (,) separator.
When the merged data appears in the Word file, one of the numbers appears
with the comma and the other two do not.

Is there any way to get the merged data in the Word file to hold to their
original foratting properties in the Excel file, so the comma will appear in
all?

Thanks,

Kevin D.

Reply to this Message

Graham Mayor - 02 Feb 2007 15:25 GMT

The most reliable method is to use a formatting switch - 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I'm doing a merge with data in an excel file to a Word letter. The
> Excel file has 3 columns with numbers formatted as numbers with a (,)
[quoted text clipped - 8 lines]
>
> Kevin D.

Reply to this Message

Kevin D. - 02 Feb 2007 16:57 GMT

Graham,

Thanks for the quick reply. I added a field switch of # "$#,###" to the
merge field and this seems to have done the trick. One other question....
Is there a way to get the numbers left justified to the dollar sign so the
result appears like this $90 as oppose to this $ 90 where the merged number
is less than 1,000

Thanks.

Kevin D.

> The most reliable method is to use a formatting switch - see
> http://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 11 lines]
> >
> > Kevin D.

Reply to this Message

Doug Robbins - Word MVP - 02 Feb 2007 17:54 GMT

You should be able to do it by using an If...then...Else field construction
that tests to see if the number is greater than 999 and applies the
appropriate formatting switch depending upon the result.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Graham,
>
[quoted text clipped - 24 lines]
>> >
>> > Kevin D.

Reply to this Message

Graham Mayor - 03 Feb 2007 08:02 GMT

For whole numbers the switch should be
\# "$,#"
or
\# "$,0"
as shown on my web site linked in my earlier post - where you will find also
the switches for decimal currency amounts.

Signature

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

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

> Graham,
>
[quoted text clipped - 31 lines]
>>>
>>> Kevin D.

Reply to this Message