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")
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";
_-@_-
Thank you very much PeterBartholomew1