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?

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?

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?

.

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?

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?