Become a Govt. Certified GST Practitioner. Batch begins 18th Nov. Register Now!

convert number into word

CA. Vipin Gupta (Accounts Officer) (146 Points)

25 January 2010

can anybody tell me the procedure of converting number into words(indian format) in excel 2007

for example 50,000 to fifty thousand

Reply
Follow
Share

5 Replies

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 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

ayushagrawal @ rediffmail.com

Upgrade to CAclubindia Pro. Subscribe Now!

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 Points)
Replied 25 January 2010

.Here is File.................

Attached File : 15 rupees convertor.xls downloaded: 1503 times

3 Like

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

https://shahshaileshs.web.officelive.com/Addins.aspx

Kaushik

Attached File : 20 indianspellnoformula.zip downloaded: 819 times

1 Like