Excel to Word mail merge problem

  • Thread starter Thread starter Ian Coates
  • Start date Start date
I

Ian Coates

I am having a problem with a mail merge document taking data from and Excel
worksheet.

The data includes currency values. Trailing zeros are not appearing meaning
that 147.50 appears as 147.5. How can I make it read 147.50 in the Word
document?

TIA

Ian
 
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
 
-----Original Message-----
I am having a problem with a mail merge document taking data from and Excel
worksheet.

The data includes currency values. Trailing zeros are not appearing meaning
that 147.50 appears as 147.5. How can I make it read 147.50 in the Word
document?
Click to expand...

Ian

I think that in the form document, the one with the fields
you can format each field. Try right_clicking on the
offending field and choose format.

Regards
peter
 
What?

--
Regards,
Tom Ogilvy


Peter Atherton said:
Ian

I think that in the form document, the one with the fields
you can format each field. Try right_clicking on the
offending field and choose format.

Regards
peter
Click to expand...
 
Back
Top