Bug in Excel 2002 to Word merge?

[Dwight Morse]

I'm frustrated by what seems to be a bug in the Excel XP
(2002) to Word XP merge process, related to numeric
fields. If I merge a number in Excel formatted with two
decimal places to a Word document (e.g., 423.61), the
number comes out in Word with a large number of decimal
places, such as 423.6093000000023. I have tried using the
=round function in Excel to force just two decimal places,
but that doesn't work. The only way around it is to use
the =text function to convert the data to a string before
merging. That works, but it's a hassle, particularly since
the "display mask" part of the =text function (the second
part of the formula) isn't a very elegant implementation.
(In a long column of numbers, a given mask won't work for
all numbers.)

I never had a problem with this in Word/Excel 97. Has
anyone else encountered this problem? If so, is there
another way around it, or are you aware of a fix?

 

[Graham Mayor]

This is not a bug. It is intentional. Microsoft changed the default method
of connection to data. Word is now expected to provide the formatting. This
is easy to do with a switch on the merge field; or you can revert to the
earlier connection method. Both options are discussed at:

http://www.gmayor.com/formatting_word_fields.htm
and
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
respectively

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[rosie]

I am having the same problem and very frustrated - can
anyone out there help?

 

[Graham Mayor]

Do you not see my reply dated yesterday in this thread?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>