Why does mail merge change the numbers in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PayPal Resolution Services - 04 Apr 2006 05:24 GMT

I have simple numbers in my excel document that mail merge draws from,
numbers like .76 when I mail merge them into msword the come out as
.759999999999999997 or .76000000000000000001 or stuff like that, I don't have
any idea what is happening to the numbers. I have tried all sorts of
different formating.

Reply to this Message

Graham Mayor - 04 Apr 2006 06:31 GMT

Word simply reads the underlying data from Excel. See
http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> I have simple numbers in my excel document that mail merge draws from,
> numbers like .76 when I mail merge them into msword the come out as
> .759999999999999997 or .76000000000000000001 or stuff like that, I
> don't have any idea what is happening to the numbers. I have tried
> all sorts of different formating.

Reply to this Message