Use text

="The value is "&TEXT(A6,"$#,##0.00")&"."

Regards,

Peo Sjoblom


wrote in message
oups.com...
I have a cell with the following:

="The value is $" & A6 & "."

Cell A6 is an integer and it's formatting is set to look like
"4,000.00". In the cell above that references A6 the value looks like
"4000".

How can I explicitly specify formatting in my "=" statement above?
Thanks!