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.

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

To add commas to the result of the formula with a text operator, you can use the TEXT function in Excel. Here's how:

1. Edit the formula in the cell where you want to display the result.
2. Replace the current formula with the following formula:
   
   ="Balance is $"&TEXT(ROUND(N53,2),"#,##0.00")
   
3. Press Enter to apply the formula.

The TEXT function takes two arguments: the first argument is the value you want to format, and the second argument is the format code. In this case, we're using the format code "#,##0.00" to add commas to the number and display two decimal places.

By using the TEXT function, you can add commas to the result of the formula without changing the underlying value. This means you can still use the result in other calculations or formulas without any issues.

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.

It works -- Thank you.

"Peo Sjoblom" wrote:

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.