Excel merge to Word

L

Leah

I am wondering if anyone has come across this problem. I
am merging dollar amounts from excel into to word. The
problem is that the amounts are formatted (i.e., 24
becomes $24.00 through the formatting option in excel)
but it will not transfer to word i.e., it comes over as
24.

Is there a way to have the formatting cross over between
programs?

Thank you in Advance.
 
G

Graham Mayor

The use of a mask as suggested by Doug is the simplest option, but Word 2002
has changed the default method of connection to Excel and the new method
expects Word to provide the formatting. You can still use the earlier
method. See the Excel data section at -
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 

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

Merging from an Excel file with graphics 1
Mail Merge - displaying a conditional number of decimals 5
Page numbering with Merged Document and IF statements 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Email Mail Merge via linked Excel sheet 0
Mail Merge Number Format 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Word 2013 DDE merge to Excel file 0

Top