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?
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?
="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?
I assume youre using something like ="Total $"&SUM(A1:A5) - This returns
text, not a number, try Custom Formatting as
"Total $"000,000
This will return a number,
Regards,
Alan.
"Jeff" <[email protected]> wrote in message
news:[email protected]...
> 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?
Custom format the cell to:
"Total " $#,##0
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"Jeff" <[email protected]> wrote in message
news:[email protected]...
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks