Format number using CONCATONATE
 

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

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

Format number using CONCATONATE
 

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

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

--
Kevin Vaughn


"ChasDavisIII" wrote:

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

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

Format number using CONCATONATE
 

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)

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

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

Format number using CONCATONATE
 

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?

"Mark Lincoln" wrote:

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)

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

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

Format number using CONCATONATE
 

try

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

adjust 2 to suit


U¿ytkownik "markmcd" napisa³ w
wiadomo¶ci ...
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?

"Mark Lincoln" wrote:

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)

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

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

Format number using CONCATONATE
 

For a percentage to 1 decimal place:

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

--
Biff
Microsoft Excel MVP


"markmcd" wrote in message
...
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?

"Mark Lincoln" wrote:

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)

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

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