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