I wanna bold text in formula cell you can check the attach.
I want this formatting:
We would be grateful if you would pay the above sum of Rupees One Hundred Thousand Only (Rs 100,000) to ABC PVT LTD at your earliest convenience. Thanking you and assuring you of our commitment to providing you our best professional service at all times.
with the use formula:
="We would be grateful if you would pay the above sum of "&SpellCurr(B5)&" "&"("&" "&CLEAN(B5)&" "&")"&" to ABC PVT LTD at your earliest convenience. Thanking you and assuring you of our commitment to providing you our best professional service at all times."
I want this formatting:
We would be grateful if you would pay the above sum of Rupees One Hundred Thousand Only (Rs 100,000) to ABC PVT LTD at your earliest convenience. Thanking you and assuring you of our commitment to providing you our best professional service at all times.
with the use formula:
="We would be grateful if you would pay the above sum of "&SpellCurr(B5)&" "&"("&" "&CLEAN(B5)&" "&")"&" to ABC PVT LTD at your earliest convenience. Thanking you and assuring you of our commitment to providing you our best professional service at all times."