software

I have almost 1,000 numbers that are formatted to display in Excel as
currency with dollar signs, commas, decimal points, and cents (for example,
1234.5 is displayed as $1,234.50). I need to use them in a merged Word
document (a pledge payment letter) but can't figure out how to quot;convertquot; them
in Excel from numbers to text AND still retain the displayed quot;dollars lookquot;
of the numbers.

Would appreciate a solution. Thanks!

Mike,
Try:

=TEXT(A1,quot;£#,###.00quot;)

or

Dim strCurr As String
strCurr = Format(Range(quot;a1quot;), quot;$#,###.00quot;)

HTH

quot;Mikequot; wrote:

gt; I have almost 1,000 numbers that are formatted to display in Excel as
gt; currency with dollar signs, commas, decimal points, and cents (for example,
gt; 1234.5 is displayed as $1,234.50). I need to use them in a merged Word
gt; document (a pledge payment letter) but can't figure out how to quot;convertquot; them
gt; in Excel from numbers to text AND still retain the displayed quot;dollars lookquot;
gt; of the numbers.
gt;
gt; Would appreciate a solution. Thanks!