Forum Discussion
Solved
Formula for Accounting format
Hello, In Cell B6, I have used the formula: ="Please Pay Tk. "&R3 In B6, it is missing the Comma after 262. I need it in Comma format, as it is in Cell R3 (i.e. 262,043.23). Thanks in advanc...
Oliullah_Siddique That would be:
="Please Pay Tk. "&TEXT(R3,"#,##0.00")
You can use this formula, also you can play with the form as you want with the text function:
=CONCATENATE("Please Pay Tk. ",TEXT(R3,"#,##0.00"))
Thank you very much Jihad Al-Jarady