SUM and ROUND with Text Question

Question

Hello, can I ask a SUM and ROUND with Text question in this forum?

Cell J37 has 5474.37
Cell K37 has 6851.93
Cell L37 has 2348.52

Cell M37 has ="Total Parent & Student "&"$ "&SUM((J37+K37+L37))

Cell M37 displays Total Parent & Student $ 14674.82

Question is how do I add a separator to read 14,674.82 and is there a way to Bold the $ 14,674.82?

Thanks
B~

Answer 1

Hi @Bruce Ringler

="Total Parent & Student "& TEXT(SUM(J37:L37),"[$$]# ##0,00")  

but not way to bold the amount only

Answer 2

To add separator , use the TEXT function, example: ="Total Parent & Student "&"$ "& TEXT(SUM((J37+K37+L37)),"#,##0.00")

About how to bold numbers and symbols in cells, you can try to use VBA to achieve, and you can post questions on the VBA tag(office-vba-dev)in the Q&A.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.