Word Merge in XP

C

Christine

Since upgrading to XP, I can't seem to get the formatting of the dates and dollar amounts from Excel to preserve when merging into Word. In fact, in Excel the Formula bar doesn't even show the formatting, as it used to in previous versions. Now after every merge from Excel into Word, I have to manually change date and dollar formats. Does anyone have the answer to this problem?
 
B

Beth Melton

Hi Christine,

Use DDE instead of OLE DB for your connection the Excel workbook.

--
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/


Christine said:
Since upgrading to XP, I can't seem to get the formatting of the
Click to expand...
dates and dollar amounts from Excel to preserve when merging into
Word. In fact, in Excel the Formula bar doesn't even show the
formatting, as it used to in previous versions. Now after every merge
from Excel into Word, I have to manually change date and dollar
formats. Does anyone have the answer to this problem?
 

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
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Word 2013 DDE merge to Excel file 0
Mail Merge Help 0
Mail Merge 4
Currency from Excel isn't merging into a Word document properly 1
Dollar amounts aren't merging from Excel into a Word document... 3

Top