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...
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?
SergeiBaklan
Oct 07, 2024Diamond Contributor
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.