Maintaining Formatting between Excel and Word Heidi 5/10/2007 2:19:00 PM 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?

Re: Maintaining Formatting between Excel and Word "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/10/2007 2:29:21 PM 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 "Heidi" <Heidi[ at ]discussions.microsoft.com> wrote in message news:D2FE84D9-8955-4F5B-BDDD-23BA2AD68677[ at ]microsoft.com... [Quoted Text] >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?