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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
It works -- Thank you.

Peo Sjoblom said:
Use

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

--
Regards,

Peo Sjoblom

(No private emails please)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i add a formula to a cell that will add or subrtact from d. 2
Dif size text with Formulas 4
Add comma after last " in a cell 14
Add a comma following a series of numbers 1
Using TEXT and &TEXT - display numbers with commas, underline text 2
PLEASE HELP??? copy every other cell value to a range of cells 3
formatting cells with numbers as text 2
HELP!!! I need to make a simple formula! 6

Back
Top