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
 
Top