Forum Discussion

Brass Contributor

Jul 19, 2022

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...

excel

Formulas and Functions

Riny_van_Eekelen
Jul 19, 2022
Oliullah_Siddique That would be:
="Please Pay Tk. "&TEXT(R3,"#,##0.00")

Riny_van_Eekelen

Platinum Contributor

Jul 19, 2022

Oliullah_Siddique That would be:

="Please Pay Tk. "&TEXT(R3,"#,##0.00")

Oliullah_Siddique

Brass Contributor

Jul 19, 2022

Thanks a lot Riny_van_Eekelen