How about storing the value in the cell, then use =text() in another cell to
format the value (into text) the way you want.
Then use mailmerge with that helper field.
disbell wrote:
Dave,
Thank you for your response. I found a way to format using text, but this
might not be my best option since the currency field in the spreadsheet may
need to be used for calculations. Thanks again for your response.
--
disbell
"Dave Peterson" wrote:
I'm not Nick and I don't use Office 2007 enough to help. So this may be a waste
of your time...
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/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
about half way down the page.
==========
I often cheat instead of racking my brain.
I'll insert another column (probably hidden!) and use:
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.
(Cheating doesn't bother me anymore <vbg.)
disbell wrote:
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
--
Dave Peterson
--
Dave Peterson