View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Merging worksheet into MS Word mail merge

No probs, Gord.
I hope that all is well with you, and best wishes for 2010

--
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Error in post.

Roger........not Biff


Gord

On Thu, 07 Jan 2010 14:22:45 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

You can format the fields at the Word end of the operation.

http://office.microsoft.com/en-us/wo...164951033.aspx

But may be easier to use the TEXT function and helpers cells as Biff
points
out.


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 10:00:01 -0800, Briggs

wrote:

I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $
and
the , do not show up in the merged letter. Any suggestions on how to
solve
this problem?



__________ Information from ESET Smart Security, version of virus
signature database 4752 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4752 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com