Forum Discussion
Solved
How to add separator (comma) inside a formula?
How to separate the value of SUM by comma in this case?
Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
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?