How to specify numeric format in formula?
 

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!

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

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

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!