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