How do I preserve the numerical percentage format whe I do mailme.

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
[email protected]> wrote in message
news:[email protected]...
>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
> [email protected]> wrote in message
> news:[email protected]...
> >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 here:

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