Merge with Excel Data

[Kevin D.]

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.

 

[Graham Mayor]

The most reliable method is to use a formatting switch - see
http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Kevin D.]

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.

 

[Doug Robbins - Word MVP]

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.

--
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 Mayor]

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.


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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>