Use

="Balance is $"&TEXT(ROUND(N53,2),"$#,##0.00")&"."

--
Regards,

Peo Sjoblom

(No private emails please)


"jlrichman" wrote in message
...
="Balance is $"&ROUND(N53,2)&"."

The display is "Balance is $12345678.90." How can I add commas?
Formatting
the cell to currency doesn't do anything. Workarounds like putting the
text
in an adjacent cell aren't acceptable here.