Formula for Accounting format

[Oliullah_Siddique]

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

[#2 · Accepted solution]

@Oliullah_Siddique That would be:

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

[#3]

Thanks a lot @Riny_van_Eekelen

[#4]

Hi @Oliullah_Siddique 

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"))

[#5]

Thank you very much @Jihad Al-Jarady

[#6]

@Oliullah_Siddique 

Another possibility is to use custom number formatting to introduce the additional text

"Please Pay Tk."#,##0.00_-;

"Your are due a refund of Tk."#,##0.00_-;

"Nothing to pay";

_-@_-

[#7]

Thank you very much @Peter Bartholomew