Merging numbers from Excel to Word

[Frustrated Mail Merge User]

Hi,

I was trying to type a bunch of letters with numbers from
an Excel spreadsheet. Even though on the Excel screen it
showed 2 decimal points (e.g. 11.22), but when I mail
merged to a Word document, it showed 11.220000000001. I
tried to copy the spreadsheet to a new one and paste value
only and edit all the cells to 2 decimal places (I went in
each cell to change the value), and it still gave me a
tonne of decimal points after I merged it. I understand
there is no way to change the decimal places in Word, but
why is it giving me all these unnecessary zeros even in
Excel it reads correctly? Any idea how to solve this?

Thank you so much!

 

[Cindy M -WordMVP-]

Hi Frustrated,

I was trying to type a bunch of letters with numbers from
an Excel spreadsheet. Even though on the Excel screen it
showed 2 decimal points (e.g. 11.22), but when I mail
merged to a Word document, it showed 11.220000000001.

It would help so much when asking questions if people would
also tell us which version of Word they're struggling with!
Then we could give very exact answers. I'm guessing you have
Word 2002 or 2003.

Go to the mail merge FAQ on my website and look at the
information in the Word 2002 section.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail