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?
|