numbers to text with formatting

[Guest]

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 "convert" them
in Excel from numbers to text AND still retain the displayed "dollars look"
of the numbers.

Would appreciate a solution. Thanks!

 

[Guest]

Mike,
Try:

=TEXT(A1,"£#,###.00")

or

Dim strCurr As String
strCurr = Format(Range("a1"), "$#,###.00")

HTH