Hello,
In B2 cell I have 149,521. This value is in number/accounting format.
In C2 cell I have given formula, ="we shipped "&B2&" CBM."
C2 returns result= we shipped 149521 CBM.
But I want the result like: we shipped 149,521 CBM.
That is including the comma.
How can I get my expected result? Attached is for you to get my question.
Thanks
Sharif
Bookmarks