How to specify numeric format in formula?

[dog_tree_catharin]

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!

 

[Dave O]

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

 

[Dave O]

Forgot: add the $ sign like this:
="The value is " & TEXT(A1,"$#,##0.00") & "."

 

[Peo Sjoblom]

Use text

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

Regards,

Peo Sjoblom