Printable View
I have my mail merge data coming from an excel speadsheet. When I merge the data, my number values do not come across formatted correctly. In Excel, they have the format structure "$111,111.00" but in Word the same number comes across as 111111.
I have tried DDE but still brings the numbers over unformatted.
Please assist.
I would reformat your excel sheet, if possible. That's the easiest way to do it. Insert a new column, make sure the columns numberformat property is "Text", and then use a function to hard code the dollar signs. A function like =DOLLAR(A1) and then autofill it down would probably do it.
Alternatively, if you can't change the source... there are field codes that can reformat the mail merge result, but I think it's easier to change your source data than to deal with nested fields in a mail merge. I'm not that familiar with them, but maybe someone else is.
This might work. In the merge document, add the \# number format switch
[vba]
MERGEFIELD Title \# $#,##0.00
[/VBA]
I didn't have any realistic data to really test it, but it worked in a mailing list I had laying around
Paul
Cross-posted (and answered) at: http://www.tek-tips.com/viewthread.cfm?qid=1684885
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
Gah... the 1 post cross-poster strikes again.
Thanks, Paul.
That would be a great addition to the board. Any new users, when posting their first post, get a screen giving a quick run-down on cross-posting etiquette.
Also cross-posted at: http://www.msofficeforums.com/mail-m...rd-2010-a.html