Forum Discussion
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...
Hi, I was hoping you could help me with getting a comma into my formulas/cells as well?
They're two formulas that are roughly the same, and they're more about formatting data from other cells in a specific way. While the numbers in the other cells that are being sourced/cited have the separator comma, the result in the formula does not. I've tried various ways of using TEXT to add it, and other standard formatting options, but I think the way the numbers are formatted in the final cell with these 'formulas' is confusing the Excel commands.
The formulas (as given to me) are:
=E4&" / "&"$"&F4&" "&G4
=L4&" / "&"$"&M4&""
The results look like, e.g.:
4 / $2386 -248
3 / $8586
So is there either a way to add a separator comma to those $ numbers, OR is there a better way to achieve these results in a single cell?
Thanks!
They're two formulas that are roughly the same, and they're more about formatting data from other cells in a specific way. While the numbers in the other cells that are being sourced/cited have the separator comma, the result in the formula does not. I've tried various ways of using TEXT to add it, and other standard formatting options, but I think the way the numbers are formatted in the final cell with these 'formulas' is confusing the Excel commands.
The formulas (as given to me) are:
=E4&" / "&"$"&F4&" "&G4
=L4&" / "&"$"&M4&""
The results look like, e.g.:
4 / $2386 -248
3 / $8586
So is there either a way to add a separator comma to those $ numbers, OR is there a better way to achieve these results in a single cell?
Thanks!
beck102015 , you are welcome
- That's it! Thank you so much!
