Mail Merge using Excel as data base

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tamara Norris - 21 May 2004 18:26 GMT

Hi,

I'm having problems with mail merge using excel. One of
the fields I have in Excel is a number (eg 100.40) and
when it comes through to Word Mail Merge the number
becomes 100.3999999999. The problem is not consistent as
some of the numbers are coming through correctly and there
doesn't seem to be any single common trait between the
ones that are not coming through correctly.

I am using XP, Word & Excel 2002.

I've tried reformatting it in Excel to 2 decimal places
but it still doesn't work??

Help, please!!!

Thanks,

Tamara

Reply to this Message

Cindy M -WordMVP- - 21 May 2004 20:29 GMT

Hi Tamara,

> I'm having problems with mail merge using excel. One of
> the fields I have in Excel is a number (eg 100.40) and
> when it comes through to Word Mail Merge the number
> becomes 100.3999999999.

This question is posted and answered an average of twice a
day....

You'll find information on this in the Word 2002 section of
my website's mail merge FAQ.

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

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

:-)

Reply to this Message

Graham Mayor - 22 May 2004 07:58 GMT

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

Signature

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

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

> Hi,
>
[quoted text clipped - 16 lines]
>
> Tamara

Reply to this Message