I would like to know how do I preserve the format of fields in excel when I
do mailmerge, and a word document is the main document, excel is the database.

I want to keep the 1,000,000 and % formats.

Thanks.

Diana Plazas

You need to learn how to do this in Word - you have to tweak the Filed I
believe
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Excel formats in Mailmerges" <Excel formats in
wrote in message
...
I would like to know how do I preserve the format of fields in excel when I
do mailmerge, and a word document is the main document, excel is the
database.

I want to keep the 1,000,000 and % formats.

Thanks.

Diana Plazas

He's right; look in Word help for numeric picture field switch.

"Bernard Liengme" wrote:

You need to learn how to do this in Word - you have to tweak the Filed I
believe
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Excel formats in Mailmerges" <Excel formats in
wrote in message
...
I would like to know how do I preserve the format of fields in excel when I
do mailmerge, and a word document is the main document, excel is the
database.

I want to keep the 1,000,000 and % formats.

Thanks.

Diana Plazas

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.



Excel formats in Mailmerges wrote:

I would like to know how do I preserve the format of fields in excel when I
do mailmerge, and a word document is the main document, excel is the database.

I want to keep the 1,000,000 and % formats.

Thanks.

Diana Plazas

--

Dave Peterson