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"
 

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

Excel does not accept text format! 0
How to count the numbers in a Word document? 0
the specified form cannot be entered because it uses more levels of nesting 2
Simple (maybe) percentage forumla 5
Sum Function has small remainder 2
How specify number format of cell value in concatenate function? 1
Using text and formatting sum function in formula 3
Paragraph numbering in Word 1

Top