can anybody tell me the procedure of converting number into words(indian format) in excel 2007
for example 50,000 to fifty thousand
5 Replies
CA Ayush Agarwal
(Kolkata-Pune-Mumbai)
(27344 Points)
Replied 25 January 2010
Dear Vipin Gupta,
Their is No Any Formula For Converting Figure into Words in MS Excel.......... But By Using VB We Can Convert it.......
So I Here Uploaded a File In Which U Can Just Put Figure & by Writting the below Formula..
=spellrupee(cell address)
U Can Convert..................
Regards,
Ayush Agrawal
CA Ayush Agarwal
(Kolkata-Pune-Mumbai)
(27344 Points)
Replied 25 January 2010
.Here is File.................
Attached File : 15 rupees convertor.xls downloaded: 1544 times
Kaushik
(Professional)
(549 Points)
Replied 26 January 2010
If you want formula to convert number into indian rupees in word without any vba code download attached excel workbook. If you want addins to convert # to Rupees in words download "Indian Rupees" by shailesh from below site. With this addins you can also format number as indian decimal system e.g. 91234567.89 to 91,23,457.89
Kaushik
Attached File : 20 indianspellnoformula.zip downloaded: 852 times
Manoj Garg
(Support on Tally Excel Password Recove)
(1987 Points)
Replied 13 May 2010
Use this file. No VBA.
Attached File : 51 in word unprotected .xls downloaded: 832 times
pawankumar
(2nd division)
(26 Points)
Replied 02 September 2011
there any formula in which we can cmbine the word with amount in that way if we change any of no or word the amount will also change
Recent Topics
- Place of Supply under GST when recipient is regist
- Income tax Basic exemptions and Capital gains
- Adding new donor to form 10 BD after due date
- RCM on MCA Fees?
- Purchase value of property sold
- 10E - Relief u/s89 Calculation
- TDS Section 194T not showing in dropdown list of s
- LTCG gainsd
- Query - Single 26QB for Payments (incl Advance) ma
- RCM ON RENT U/S 9(3)
Related Threads
Trending Online Classes
CAclubindia
