Forum Discussion
Haytham Amairah
Feb 05, 2017Silver Contributor
How to add separator (comma) inside a formula?
How to separate the value of SUM by comma in this case?
- Feb 06, 2017
Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
SergeiBaklan
Feb 06, 2017Diamond Contributor
Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
Bikash Chandra Das
Sep 06, 2018Copper Contributor
If i want to use decimal places in the number, Formula?
- SergeiBaklanSep 06, 2018Diamond Contributor
Please check this https://www.ablebits.com/office-addins-blog/2016/07/07/custom-excel-number-format/