Issue with formatting cell numbers.

[gthemerc]

="The total cost of the concrete provided for this project is " & Results!D15 & "."

I would like my Results!D15 to be displayed as a value with commas and a $ symbol. I set the cell to currency and the original value is in that format but it just appears as a normal number. I'm having the same issue with % showing up as decimals.

[martindwilson]

replace Results!D15
with
TEXT(Results!D15,"£0.00")
or whatever you currency format is

for %
simply mult decimal by 100 and add % as text
e.g
="fred "&B1*100&"%"

[gthemerc]

Exactly what I was looking for, Thanks!