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?
Peter Jamieson - 10 May 2007 15:29 GMT
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
>I have data in Excel 2007 that is set to automatically round to two decimal
> places
[quoted text clipped - 5 lines]
> options
> on previous version. Any ideas?