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.
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 Topic
- Section 194DA
- CPA for US tax
- LTCG on unlisted foreign shares acquired in inheri
- SBI Funds Management IPO Allotment on July 17: Lis
- PF Final settlement shown in Salary Form 16 FY 26-
- ITR3 online utility: Part B TTI is populating fiel
- Sale of rural agriculture land
- How to show Capital Gain on gifted property
- TIS Glitch Alert : inflated summary
- IT returns of partners
Related Topics
CAclubindia
