Numbers in Word have extra decimal places

[StephenW]

I have a mail merge in Word 2002 with an Excel 2002
spread sheet as it data source. The values in one column
are two decimal place numbers, but when the data is
brought into Word some of the numbers come across with
14 decimal places. The cell values are all 2 decimal
places and there is no formatting or calculations
done on the column in Excel. It is not every number
in the column and I can see no pattern as to which ones
get the extra decimal places.

Any Ideas? I know I can format the field in Word to
get the decimal places back to where they should be, but I
don't see where Word is getting the values.

Another thing I noticed is that in the Data Source dialog
the column order is changed so that a column called "Name"
appears first, even though its the 4 column in Excel.
I know this will not affect the mail merge, but some of my
users thought there was a problem and brought it up.
Thanks

 

[Graham Mayor]

See http://www.gmayor.com/formatting_word_fields.htm.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

 

[macropod]

Hi Stephen,

If you examine the Excel file, you will find that the problem data does
indeed have the extra digits after the decimal place. You may need to format
the cells as 'general' and expand the column width to see the trailing
digits.

Cheers