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