Exporting to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The format of some of the data I import into Word changes. For example, a two-digit number in the Excel spreadsheet may become a 10-digit number when it arrives in Word. I've tried changing the formatting in Excel but nothing seems to work

Any suggestions would be appreciated!
 
In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting will be retained.

If you have to connect through a different source, you can format the
fields in the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
You're welcome. (I added the Tools>Options instructions because someone
complained about it recently.)
 
Back
Top