SUM and ROUND with Text Question

Bruce Ringler 61 Reputation points
2022-02-06T18:16:53.98+00:00

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~

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,441 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,636 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Ceasar Chen_MSFT 4,391 Reputation points
    2022-02-07T09:06:06.957+00:00

    To add separator , use the TEXT function, example: ="Total Parent & Student "&"$ "& TEXT(SUM((J37+K37+L37)),"#,##0.00")
    171829-image.png
    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.

    0 comments No comments