Excel: Return number within text so it has a comma
Posted on 2014-04-13
I have the following formula in an excel cell:
="Test text $"&TEXT(C10,"#.00")&" test text"
I would like the integer value in the middle to return with a comma separator.
e.g currently this formula returns:
Test text $1200.50 test text
But I want:
Test text $1,200.50 test text
How do I edit the formula so it returns the comma?