Forum Discussion
Solved
Joining Text and Formatted Number
I am using the formula CONCAT("Total Cost ",ROUND(SUM(A2:A50),0)) in a cell to get the result Total Cost 123456 (where SUM(A2:A50) is equal to 123456). Is there some way to format the number to 123,456?
BillCPA Yes, use CONCAT("Total Cost ",Text(ROUND(SUM(A2:A50),0),"#,000"))
5 Replies
BillCPA Yes, use CONCAT("Total Cost ",Text(ROUND(SUM(A2:A50),0),"#,000"))
DexterG_III - thank you - looks good.
