I want to import a workbook into a mail merge document and the currency formating doesn't come through. Is there a formula I could implement to change the text in a cell from "1234567.89" to read "$1,234,567.89" so it appears that way in the mail merge?
you can use the formatting switches in the mergefield in Word
- Hit ALT-F9 to show all field codes
find your field, for example if it is called "amount", use this format switch
{ MERGEFIELD "amount" \# $#,###.00 }
If you want to ensure that the merge field has the same font and size, add the \* MERGEFORMAT switch.
hth
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
The formatting for mailmerge fields is applied as field switches in the mergefield in Word.
See for example,
http://office.microsoft.com/en-us/wo...871801033.aspx
http://office.microsoft.com/en-us/wo...CH061047321033
http://office.microsoft.com/en-us/wo...CH061047321033
EDIT: Must have been snoozing ...
Last edited by shg; 11-13-2009 at 07:40 PM.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Great. Thank you both. I got it working.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks