How to add commas to the result of a formula with a text operator?

J

jlrichman

="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.
 
P

Peo Sjoblom

Use

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top