Thread: no comma separator for ="total"&"$ "&sum(a1:a10)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
  
Posts: 176
Default 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?
Reply With QuoteReply With Quote