| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
no comma separator for ="total"&"$ "&sum(a1:a10)
I'm trying to put a word "Total" before a summation of cells. This is
working but I get a solid number back. I'd like to have the number show a comma separator. I get Total $187242 I'd like to get Total $187,242 Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
no comma separator for ="total"&"$ "&sum(a1:a10)
="Total "&TEXT(SUM(A1:A10),"$0,0")
-- Regards, Dave "Jeff" wrote: I'm trying to put a word "Total" before a summation of cells. This is working but I get a solid number back. I'd like to have the number show a comma separator. I get Total $187242 I'd like to get Total $187,242 Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
no comma separator for ="total"&"$ "&sum(a1:a10)
I assume youre using something like ="Total $"&SUM(A1:A5) - This returns
text, not a number, try Custom Formatting as "Total $"000,000 This will return a number, Regards, Alan. "Jeff" wrote in message ... I'm trying to put a word "Total" before a summation of cells. This is working but I get a solid number back. I'd like to have the number show a comma separator. I get Total $187242 I'd like to get Total $187,242 Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
no comma separator for ="total"&"$ "&sum(a1:a10)
Custom format the cell to:
"Total " $#,##0 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jeff" wrote in message ... I'm trying to put a word "Total" before a summation of cells. This is working but I get a solid number back. I'd like to have the number show a comma separator. I get Total $187242 I'd like to get Total $187,242 Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comma Deliminated File Format | Excel Discussion (Misc queries) | |||
| Extra comma at the end of a function | Excel Discussion (Misc queries) | |||
| Applying Indian comma style | Excel Discussion (Misc queries) | |||
| Importing a part of a big comma delimited csv-file | Excel Worksheet Functions | |||
| Comma is not visible in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
