Nick,

I am using Word 2007 and Excel 2007. When I try to use ODBC as the
transport method for the Mail Merge in Word, it still does not bring the
currency formatting over from Excel to Word. I have clicked the Confirm Data
Source Box located under Word Options, select the ODBC connection option,
selected the worksheet that contains the data, and even restarted my
computer. Is there something else that needs to be done in order to make the
currency formating transport from Excel 2007 to the Word 2007 Mail Merge?
--
disbell


"Nick Hodge" wrote:

Bruce

You will it doesn't travel by any of the transport methods for mailmerge
(DDE or ODBC)

You will need to transfer the data to text. I use a helper column and the
TEXT function and then kill the formula with paste special+Values

=TEXT(B1,"£#,##0.00")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/


"Perkgolf" wrote in message
...
Hi,
I'm losing my number formatting when I merge my Excel sheet into my Word
doc? Any ideas?

Thanks
Bruce