Format number using CONCATONATE

[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")

 

[Guest]

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

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

 

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

 

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

 

[Jarek Kujawa]

try

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

adjust 2 to suit

 

[T. Valko]

For a percentage to 1 decimal place:

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