View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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?