Sep 15 2022 07:44 AM
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?
Sep 15 2022 07:48 AM
Solution@BillCPA Yes, use CONCAT("Total Cost ",Text(ROUND(SUM(A2:A50),0),"#,000"))
Sep 15 2022 11:16 AM
Sep 15 2022 11:20 AM
Sep 15 2022 07:48 AM
Solution@BillCPA Yes, use CONCAT("Total Cost ",Text(ROUND(SUM(A2:A50),0),"#,000"))