Keeping number formats (eg. 5.15%) in Excel/Word Mail Merge

[Ximena]

When I try to perform a mail merge from excel to word, the excel cells have
the correct format, eg. decimal places, % and $ signs. When I conduct the
merge, I lose the % and $ signs, and numbers are blown out to ~ 15 decimal
places.

This did not occure with Office 2000. I'm sure I just need to tick a format
box or something but I don't know where?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?WGltZW5h?=,

When I try to perform a mail merge from excel to word, the excel cells have
the correct format, eg. decimal places, % and $ signs. When I conduct the
merge, I lose the % and $ signs, and numbers are blown out to ~ 15 decimal
places.

This question comes up at least daily in this group...

See the mail merge FAQ on my website, the section on Word 2002/2003

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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

 

[Graham Mayor]

Word is now expected to provide the formatting - see
http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>