How to add commas to the result of a formula with a text operator?
="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.
|