in mail merge how do i convert currency from excel to word

G

Guest

I have a spreadsheet that uses currency. When I mail-merge into Word
document, the currency doesn't convert correctly. For example the $ sign
does not come across, the diget 0 does not convert if its the last digit
(i.e. in excel $20.50 - converts to Word in mail merge as 20.5) and if the
currency does not end in 0, it converts with 4 digits after decimal point
(i.e. $20.51 converts to 20.5142).
 
J

JE McGimpsey

Use a numeric switch in your merge fields within Word. See "Numeric
Picture (\#) field switch" in Word Help.
 

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

Excel currency format does not translate correctly in a Word merge 2
Mail Merge - Thousand separators & Decimals 0
Mail Merge - Thousand separator and decimals 1
Dollar amounts aren't merging from Excel into a Word document... 3
Currency merge from Excel to Word 1
Using Excel as data for mail merge... 1
If I format a currency formula in excel ... 1
0 missing from currency when merging documents 1

Top