Today I Wanna give you all Number to word convertor add in
you can get it from the following link
http://cid-8debefc810167f39.skydrive.live.com/self.aspx/.Public/No%20in%20word%20Excel%20Addin.xla.xls
all you have to do is to download this from the following link and add it to your add-in
for those who don't know how to add a add-in in Excel here is the details.
(Detail are for Excel 2007)
First go to Office Button on the top of Excel-file (Round One)
Than go to Excel Options-> Add in-> Manage Excel Add-in (Go)->
A new window will appear called Add In
go to Browse and pick up the file from the specified location (Where you stored the addin)
mark the addin name appear in the list and click ok
Now how to use it
It is so simple just put the formula on the cell (=Spellnumber(cell no.))
And your value will convert in words for exp.
If in Cell No. A1 Contains 1000 than put the formula in cell B1 (=spellnumber(A1))
It will provide you value of "Rupees One Thousand"
Thanks & Regards
Hemant
Microsoft Excel the best software, in my opinion, that is created by human being. In this blog, you will find related stuff with this software. I am not here to solve any problem with Excel. I am here to helping you all and my self to understand the software and gain more knowledge about it.
Subscribe to:
Post Comments (Atom)
Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...
-
If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...
-
Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
-
I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
No comments:
Post a Comment