Hi

I have this formula and I want the answer to come back as TOTAL - $98,104.
I also want the text to wrap as it takes up too much space, that is why I
could not use Custom Format.

This is my formula ="TOTAL"&" - "&"$"&SUM(AA4:AA78)
This is my answer TOTAL - 98103.9666666667
This is what I would like to happen TOTAL
$98,104
I am using Excel 2007

Thanking you
Anne