Format number using CONCATONATE

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

Guest

How do I use the folowing formula and show the number with a unit seperating
comma like 12,469?

=CONCATENATE(SUM(F7:F26)," Brick")
 
Since you can use & for concatenate, how about something like this:

=TEXT(SUM(F7:F26), "#,###") & " Brick"
 
If the cell will always contain the text ", Brick" then you can use a
custom number format for the cell:

#,##0", Brick" (if you need no decimals)

#,##0.00", Brick" (if you need two decimals)

Then just use the formula:

=SUM(F7:F26)
 
Just reading this thread, I have a similar problem. How do you format for %?
I have a line that says ="and this represents "&b4/c4&" of the total". Anyone?
 
try

="and this represents "&ROUND(b4/c4*100,2)&"% of the total"

adjust 2 to suit
 
For a percentage to 1 decimal place:

="and this represents "&TEXT(B4/C4,"0.0%")&" of the total"
 
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

Selective concatonate 3
RE add cells together if value has a formula 1
How do I copy a function formula? 3
Look up formula 4
Combining If and Concatonate 3
How specify number format of cell value in concatenate function? 1
Missing count of age to a group of ages 5
Using text and formatting sum function in formula 2

Back
Top