| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Maintaining Formatting between Excel and Word
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? |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Maintaining Formatting between Excel and Word
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" wrote in message news  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? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Email a Word 2003 file maintaining links to Excel file | Microsoft Word Help | |||
| Maintaining style formatting in AutoText entries | Microsoft Word Help | |||
| Maintaining formatting when inserting file | Page Layout | |||
| How do I keep the formatting when pasting from Excel to Word as a. | Microsoft Word Help | |||
| Maintaining Formatting When Copy and Pasting | Microsoft Word Help | |||
Linear Mode
