Excel data merged in Word

[mmorin]

I am trying to merge data from an Excel spreadsheet into a Wor
document.

This is the way the data appears in the Excel spreadsheet :

Date Percentage Amount
26-Jun-1950 0.2 13,952.96

But once the information is merged to the Word document it appears as:

Date Percentage Amount
6-26-1950 0.2000000000000001 13,952.960000000001

How can I get the data to appear in my merged document as it appears i
my Excel spreadsheet.

Thanks.

MMori

 

[Dave Peterson]

You could use some helper cells and create strings for each field--then use
those helper values:

=text(a1,"dd-mmm-yyyy")
=text(b1,"0.0")
=text(c1,"#,##0.00")

or you could do some magic at the MSWord side.

Debra Dalgleish posted this for a different question, but I bet you could modify
it (multiple times!):

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