[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

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


Kevin D. wrote:
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.

[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.

"Graham Mayor" wrote:

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


Kevin D. wrote:
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.

[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

"Kevin D." wrote in message
...
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.

"Graham Mayor" wrote:

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


Kevin D. wrote:
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]

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

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


Kevin D. wrote:
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.

"Graham Mayor" wrote:

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


Kevin D. wrote:
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.