Forum Discussion

Copper Contributor

Sep 15, 2022

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,...

excel

DexterG_III
Sep 15, 2022
BillCPA Yes, use CONCAT("Total Cost ",Text(ROUND(SUM(A2:A50),0),"#,000"))

DexterG_III

Iron Contributor

Sep 15, 2022

BillCPA Yes, use CONCAT("Total Cost ",Text(ROUND(SUM(A2:A50),0),"#,000"))

BillCPA

Copper Contributor

Sep 15, 2022

DexterG_III - thank you - looks good.

DexterG_III
Iron Contributor
Sep 15, 2022
BillCPAMy pleasure. Would you kindly mark my response as the solution if it works?

Regards,
Dexter
- BillCPA
  Copper Contributor
  Sep 15, 2022
  This is my first time here - did I mark correctly?
  - DexterG_III
    Iron Contributor
    Sep 15, 2022
    BillCPA yes, perfect & thank you.