If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging with an excel document
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? |
#2
|
|||
|
|||
Merging with an excel document
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)"} -- 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 "MC" wrote in message ... 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? |
#3
|
|||
|
|||
Merging with an excel document
The website Rich/rerat has excellent information on several formating issues
that arise when merging with an excel document. "Rich/rerat" wrote: 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)"} -- 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 "MC" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|