numbers to text with formatting
 

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!

numbers to text with formatting
 

Mike,
Try:

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

or

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

HTH

"Mike" wrote:

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!