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!