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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ximena - 08 Jul 2005 06:26 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 08 Jul 2005 09:15 GMT

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 :-)

Reply to this Message

Graham Mayor - 08 Jul 2005 10:36 GMT

Word is now expected to provide the formatting - 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> When I try to perform a mail merge from excel to word, the excel
> cells have the correct format, eg. decimal places, % and $ signs.
[quoted text clipped - 3 lines]
> 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?

Reply to this Message