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?