Currency in merge from Excel

G

Guest

Excel data source contains a column with currency values (e.g. $10,000).
When used as data source for merge in Word, merge results in 10000. Loses
all currency formatting. We can add $ character, naturally, but how to get
the commas in there??? Better yet, how about, "How do you get Word to import
currency as currency, so you don't have to add a bunch of formatting that
should already be there???" Any thoughts / help much apprciated.
 
B

Beth Melton

You can add a numeric switch to the mail merge field or use a
different method to connect to your Excel data source that will also
carry over the formats. Go to Tools/Options/General and turn on
"Confirm conversion at open". Then select your Excel data source again
and when prompted use the DDE method instead of OLE DB.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency from Excel isn't merging into a Word document properly 1
Mail merge between Word and Excel 1
Formatting a Merge field from xls doc 4
Mail Merge Using Excel 1
Retaining source formatting from Excel with a mail merge in Word 2
Mail Merge Currency Issue 2
Excel currency format does not translate correctly in a Word merge 2
Dollar amounts aren't merging from Excel into a Word document... 3

Top