| 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? |
| 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) | |||
Threaded Mode
