| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Number format for Combobox | Excel Discussion (Misc queries) | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Hybrid Mode
