Merging Excel into Word letter

  • Thread starter Thread starter Jaclyn
  • Start date Start date
J

Jaclyn

Hi, hoping someone can help.

Column A - Start date
Column B - Termination date
Column C - (Termination date-Start date/365 = Total years)

I've formatted Column C to show no decimal points and to
be rounded up to have the total number of years.

The problem I'm having is when I merge this info into a
Word letter, they will put the exact Total with decimal
numbers and not the info that I've formatted. Also the
date would be formatted wrong in the merge.

Any ideas? Thanks a bunch.
 
As answered in .worksheet.functions --
'=====================================
After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you 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
'=====================================
 
Thank you so much Debra!
-----Original Message-----
As answered in .worksheet.functions --
'=====================================
After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you 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
'=====================================



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
Click to expand...
 
Back
Top