Home

How to add separator (comma) inside a formula?

Haytham Amairah
Super 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

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?

Highlighted

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
No Assignments Tab in Microsoft Teams
Nick Davies in Microsoft Teams on
25 Replies
Accessing Team Calendar on iPhone
Abbas Jaffar Ali in Microsoft Teams on
8 Replies
microsoft forms
Mapuleng Koloba in Microsoft Forms on
2 Replies
Inserting links
Jessica Carver in Microsoft Teams on
13 Replies
Create private channel in a team
Catalin Prata in Microsoft Teams on
59 Replies
Teams Files Backup and Restore
Vivek Desai in Microsoft Teams on
16 Replies