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
Replies (21)
https://support.microsoft.com/kb/213360
Rachana
Download this small utility from our share file section
hi rakesh
thank you very much
There is nothing in excel to convert no. into excel except one function of =BAHTTEXT but not in eglish. you have to make program in macro
Deepak
If u download the utility which is mentioned by rakesh then u will get proper output
Try it it is really helpfull
Hi,
For this type of conversion u wiil have to visit website www.asap- utilities.com and download the toolbar.
After Downloading, Go to option numbers and select spell number.
if u still dont get it let me know.
regards
Siddharth
i have excel file but you can use without my permission. you can see results
I also need similar help
I have the EXCEL file which can convert and show numbers in Ruppes upto 99 crores. (Some other files give only number or text in Dollars).
Give you email IDs I will email directly with instructions.
Give you email IDs I will email directly with instructions.
Hi Vijay,
Can u pls mail me the file on siddharthdoshi @ rediffmail.com.
Thnx in advance
need formula for converting no. value in Text
Rs. 100 As One hundred only.
Is it posible in ecel.
Here is the attched file helps you to covert numaric value in alphabet.
pls go to Toos> Macro>visual basic editor and copy the matter in your excel file's Visual basic
then it will work
Hi,
Can you mail me this file on my mail id (mukesh.rks @ gmail.com)
| Originally posted by :Guest | ||
| " | i have excel file but you can use without my permission. you can see results | " |
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
