Merging with an excel document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MC - 11 Oct 2007 16:37 GMT

I have created my master document in word, selected the excel file to merge
with, and inserted my merge fields. When I merge the word document with the
excel file the currency that is merging from excel to word no longer appears
as currency, it appears as a regular number. Ex. Excel $18,002.06 - Word
18002.06 How can I fix this problem?

Reply to this Message

Rich/rerat - 11 Oct 2007 17:58 GMT

MC,
Graham Mayor has an excellent site about switches:
http://www.gmayor.com/formatting_word_fields.htm

For your situation you should add the following switch for the currency
mergefield:

{mergefield total \# "$,0.00;($,0.00)"}

Signature

Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>

Reply to this Message

MC - 11 Oct 2007 19:48 GMT

The website Rich/rerat has excellent information on several formating issues
that arise when merging with an excel document.

> MC,
> Graham Mayor has an excellent site about switches:
[quoted text clipped - 9 lines]
> as currency, it appears as a regular number. Ex. Excel $18,002.06 - Word
> 18002.06 How can I fix this problem?

Reply to this Message