Maintaining Formatting between Excel and Word

H

Heidi

I have data in Excel 2007 that is set to automatically round to two decimal
places
and maintain currency formatting, but when I merge it into Word 2007, that
formatting is lost. Is there a way that this number formatting can be
maintained when merged to Word 2007?

I used to check the (confirm conversion at Open) box in the general options
on previous version. Any ideas?
 
P

Peter Jamieson

You can still do that if you need the DDE connectivity but you have to check
Word 2007|Office Button|Word Options|Advanced|General|"Confirm File Format
conversion on open"

Peter Jamieson
 

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

Paste to excel from word - auto format problem 1
Mail Merge - displaying a conditional number of decimals 5
How can I maintain Excel's number formatting when merging to Word? 7
Converting URLs in comments to Markdown-formatted links 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
mail merging conditional formatted cell values - especially colour 1
Merging values into Word documents 7
Word 2013 merge Excel, DDE conncetion path problem 0

Top