G
Guest
Hi,
I'm losing my number formatting when I merge my Excel sheet into my Word
doc? Any ideas?
Thanks
Bruce
I'm losing my number formatting when I merge my Excel sheet into my Word
doc? Any ideas?
Thanks
Bruce
Dave Peterson said:Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:
http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm
about half way down the page.
Nick Hodge said: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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.