Word merge from Excel causes inflation of decimal places

[gideon]

Whne performing a merge to Word from an Excel spreadsheet,
the resulting document shows instead of the currency value
in Excel of $4.51, a merged value in Word of
$4.51000000000009 or something similar. The original Excel
sheet with original values and merged works fine, but when
I add a new customer to the spreadsheet and merge it to
Word the resulting merge is expanded to include the
extraneous decimal places.
What is causing this?
I am heading down the path of thinking that it might be an
older Excel sheet that when saving the new data to it
causes this anolmaly but am asking to see if anyone has a
hndle on this.
TIA
Gideon

 

[Guest]

-----Original Message-----
Whne performing a merge to Word from an Excel spreadsheet,
the resulting document shows instead of the currency value
in Excel of $4.51, a merged value in Word of
$4.51000000000009 or something similar. The original Excel
sheet with original values and merged works fine, but when
I add a new customer to the spreadsheet and merge it to
Word the resulting merge is expanded to include the
extraneous decimal places.
What is causing this?
I am heading down the path of thinking that it might be an
older Excel sheet that when saving the new data to it
causes this anolmaly but am asking to see if anyone has a
hndle on this.
TIA
Gideon
All OK, fixed by Confirm conversion at open in Word.

 

[Dave Peterson]

Debra Dalgleish posted this to a similar question today. I couldn't find it on
google (yet), so here goes:

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 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

(Are you Helen?)