Insert a comma to seperate numbers in an @ sum formual

[tcrjmom]

Hello All,

I'm not sure what I'm asking can even be done but here it goes:
I have a formula to look at another cell which has a fomula that provides a currency symbol
then add the total of four other cells. The problem that I have is is that the @sum total comes over as a whole number without a seperator comma.

=AA1&SUM(D22:O22)

The info comes over as $10000

What I need it to look like is $10,000.00 - is this possible with a formula?

Thank you, in advance, for your help.



Regards,

[Jonmo1]

Try

=AA1&TEXT(SUM(D22:O22),"#,##.00")

[tcrjmom]

OMG - thank you so much - WORKED PERFECTLY -

[Jonmo1]

You're welcome.