| Originally posted by :Rachana Gadage | ||
| " | hi Can anybody tell me a formula for converting number into text format in Excel. e.r.12000 output should be Rs. Twelve Thousand Only |
" |
Menu
Convert number into text in excel
| Originally posted by :Guest | ||
| " | need formula for converting no. value in Text Rs. 100 As One hundred only. Is it posible in ecel. |
" |
12050
i want to convert number into text e.g.
1256= one thousand two hundred fifty six
can any body tell me how it possible in excel
how i can convert fugure in words in excel
Mr. Nitin U just have 2 install the addin 2 ur office pack which is attached here.
Then u have 2 go 2 any cell and write =rswords(select the number u want 2 write in words)
Try...
=spellrupee( adress of number cell)
Recent Topics :
- LTCG: Home Loan Principal Repayment?
- Ims action relationship query
- GIFT REGARDING
- TDS on salary to non resident managing director
- Ewaybill and Transport documents (Lorry receipt)
- LTCG on sale of Builder Buyer Agreement
- Rule 13(2)(h) and valuation of CCDs
- Leave encashment, New labour code, Management cadr
- GST clarification needed:
- TDS processed with short deduction default
Related Topics :
CAclubindia
