Mail Merge
 

When I mail merge using excel and word 2007 the format I use for the numbers
in Excel does not carry over, eg £1.23 comes over as 1.23, and more of a
problem 1.00 or £1.00 comes over as 1. Is there a simple answer?

Mail Merge
 

See http://office.microsoft.com/en-ca/wo...164951033.aspx
It does not mention Office 2007 but the methods apply
More at
http://wordprocessing.about.com/od/u.../NPFSwitch.htm
http://word.mvps.org/FAQS/MailMerge/...DataSource.htm

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"ianspaul" wrote in message
...
When I mail merge using excel and word 2007 the format I use for the
numbers
in Excel does not carry over, eg £1.23 comes over as 1.23, and more of a
problem 1.00 or £1.00 comes over as 1. Is there a simple answer?

Mail Merge
 

Mailmerge does not recognise Excel formatting, just the real data.

You can convert the data in Excel to text values before merging.

See David McRitchie's site for how-to's

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Or Formatting can done at the Word end by formatting the fields the Excel
data is dropped into.


Gord Dibben MS Excel MVP



On Mon, 23 Nov 2009 10:23:02 -0800, ianspaul
wrote:

When I mail merge using excel and word 2007 the format I use for the numbers
in Excel does not carry over, eg £1.23 comes over as 1.23, and more of a
problem 1.00 or £1.00 comes over as 1. Is there a simple answer?

Mail Merge
 

Some more
Force Word to use the number format you want
http://homepage.swissonline.ch/cindymeister/mergfaq.htm

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://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"ianspaul" wrote in message
...
When I mail merge using excel and word 2007 the format I use for the
numbers
in Excel does not carry over, eg £1.23 comes over as 1.23, and more of a
problem 1.00 or £1.00 comes over as 1. Is there a simple answer?

Mail Merge
 

Thanks for your help. This does not seem to work with 2007. I'm sure it
should be simple but maybe I'm missing something.

"Bernard Liengme" wrote:

See http://office.microsoft.com/en-ca/wo...164951033.aspx
It does not mention Office 2007 but the methods apply
More at
http://wordprocessing.about.com/od/u.../NPFSwitch.htm
http://word.mvps.org/FAQS/MailMerge/...DataSource.htm

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"ianspaul" wrote in message
...
When I mail merge using excel and word 2007 the format I use for the
numbers
in Excel does not carry over, eg £1.23 comes over as 1.23, and more of a
problem 1.00 or £1.00 comes over as 1. Is there a simple answer?

.