ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I preserve the numerical percentage format whe I do mailme. (https://www.excelbanter.com/excel-discussion-misc-queries/21821-how-do-i-preserve-numerical-percentage-format-whe-i-do-mailme.html)

Excel formats in Mailmerges

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

Bernard Liengme

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




PegL

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





Dave Peterson

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


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com