Merging worksheet into MS Word mail merge
 

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?

--
Briggs

Merging worksheet into MS Word mail merge
 

Hi

Instead of just referring to the cell e.g. A1 use
=TEXT(A1,"[$$-409]#,##0.00")

--
Regards
Roger Govier

"Briggs" wrote in message
...
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?

--
Briggs

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

The message was checked by ESET Smart Security.

http://www.eset.com




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

The message was checked by ESET Smart Security.

http://www.eset.com

Merging worksheet into MS Word mail merge
 

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?

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?

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

Merging worksheet into MS Word mail merge
 

Thanks for the greetings.

Good year so far although the golf is a little sparse.

Too many frost delays.


Gord

On Thu, 7 Jan 2010 23:32:04 -0000, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:

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

Merging worksheet into MS Word mail merge
 

Hi Briggs,

To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# "$,0.00;($,0.00);") zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.


--
Cheers
macropod
[Microsoft MVP - Word]


"Briggs" wrote in message ...
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?

--
Briggs