Format number using CONCATONATE

C

ChasDavisIII

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

=CONCATENATE(SUM(F7:F26)," Brick")
 
K

Kevin Vaughn

Since you can use & for concatenate, how about something like this:

=TEXT(SUM(F7:F26), "#,###") & " Brick"
 
M

Mark Lincoln

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)
 
M

markmcd

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?
 
J

Jarek Kujawa

try

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

adjust 2 to suit
 
T

T. Valko

For a percentage to 1 decimal place:

="and this represents "&TEXT(B4/C4,"0.0%")&" of the total"
 
Top