Hello,
i am trying to add comma on a column and it has text as the end. how can i add comma to it.
current output
F1 | F2 |
43875 | 2134234 |
46767 | 698798 |
1232343 | 6756757 |
Total Sum | 689789 |
Expected Output
F1 | F2 |
43,875.00 | 2,134,234.00 |
46,767.00 | 698,798.00 |
1,232,343.00 | 6,756,757.00 |
Total Sum | 7,689,789.00 |
i also tried Toround, ToString and when i change column to double from string then i last line become Null from Total Sum.
Solved! Go to Solution.
@kauser
I just learned recently that we can add thousand seperator with ToString function.
Thanks for your advice. its work but if there is decimal number then it wont work. can you please help to on input data below there data have decimal
43875.45 | 2134234.34 |
46767.78 | 698798.56 |
1232343.12 | 6756757.34 |
Total Sum | 689789.57 |
@kauser
I did not consider the decimal number since it was not in your sample.
maybe we can do something like this.