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
MVP
Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
melika1213
Oct 07, 2024Copper Contributor
SergeiBaklan hi can you help me i want to use VLOOKUP formula but when i add "," camma it shows no reaction and i can't add other pyrometer so how can i fix it?
- SergeiBaklanOct 07, 2024MVP
Who knows, perhaps you shall use semicolon instead of comma in your locale, or something else. Better if you start new discussion here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral with your question, giving more details which exactly formula you try to use and on which data.