View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Merging worksheet into MS Word mail merge

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?