Home

How to add separator (comma) inside a formula?

Haytham Amairah
Valued Contributor

How to add separator (comma) inside a formula?

How to separate the value of SUM by comma in this case?

Capture.JPG

 

 

 

 

 

3 Replies
Highlighted

Re: How to add separator (comma) inside a formula?

Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...

Re: How to add separator (comma) inside a formula?

Thank you Mr. Baklan, this is exactly what I want :smileyvery-happy:

 

But I have noticed another code gives the same result.

The code is: #,##0

What's the difference between it and the code you mentioned?

Re: How to add separator (comma) inside a formula?

Actually no difference, for me it was faster enter the formula ans copy/paste it here. In general, for whole numbers you may use something like TEXT(A1,"#,#"). Another story if you would like to make different formatting for positive and negative numbers, add text and or colors into formatting, etc - all that additional symbols matter.

 

In particular, you may format your cell with =SUM(D3:D12) as "Total: "#,### (enter this into the Custom format of the cell) that gives the same result.

 

Comma just separates your number on thousans, millions, billions, etc.

 

More about formatting is here

https://support.office.com/en-us/article/Number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68

https://support.office.com/en-us/article/Create-or-delete-a-custom-number-format-78f2a361-936b-4c03-...

 

and i guess in many other places

 

 

Related Conversations
How can I delete Teams free organization?
Kazuaki Tauchi in Microsoft Teams on
3 Replies
Auto-Add new employees
Mathias Koprek in Microsoft Teams on
9 Replies
Linking OneDrive to New Microsoft Teams Channel
Kelly Charlton in Microsoft Teams on
5 Replies
Adding an Existing OneNote notebook to Teams
CC Adeyemo in Microsoft Teams on
18 Replies