Converting figure to word in excel

Excel 6604 views 9 replies

In day to day use of excel,in many files we convert figures in words as its a requirement for many institutions to show all the important figures into words also .While converting some times ,some errors are inevitable and sometimes these small errors may becomes the reason for loss of thousands ,due to rejection of tender or project reports.so every body things that there may be some command in excel which they does not know ,but as far as my knowledge is concerned ,there is no such command in excel as such ,by which this Job can be done.However we can do this Job by installing a small excel add in file in excel .Yes we can do this.I am doing this from last three four years,so I think I should also share this with you also .I know that many of my friends may have this utility ,but I hope this utility still helpful for many.

How to use


1.download the attached "
convert figure into word excel" from here and UNZIP IT and save the word.xla file in hard disk
2. save it in a Folder permanently.(do not change the location of file after installation)
3. Now open excel Goto Tools>add in >browse (browse the file where you have stored the downloaded the file and select the file)
4 press ok
that's all

Now to convert a figure in to words type in formula bar
=word (cell number in which figure are given)

suppose figures are given in A2 then command should be =word(A2)
that's all

You require
Win 95/98/NT/2000/XP, MS Excel 97/2000
 
SOURCE - SIMPLETAXINDIA.ORG
 
Thanks and regards.,
Deepak.R

Attached File : 55 excel shortcuts figure 2 word.zip downloaded: 984 times
Replies (9)

good one

Hi Deepak,

I have downloaded it and used all the connections BUT it shows that the file is corrupted. Will you please help me out as I am very much interested in such things.

 

Hi Pankaj,

 

If you have problem you can try another nice alternate addins called "Indian Rupees" by shailes from below site.

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

 

If the website is down you can see below attachment.

 

Kaushik

 

pankaj.,

 

send ur mail id to innovativedeepak87 @ gmail.com..

i will fwd as a mail to u...
 

check this excel addin , u have to use formula =num2text(a1)  a1 is cell of the amount

 

if you need any clarification comment me

if you like it thanks me

Note that rar files are not unziped by some systems without having winrar software.

Hi frenzz., am herewith attaching the file named inward.xla. Hope this will resolve ur prob..

save the inword.xla file in hard disk
 save it in a Folder permanently.(do not change the location of file after installation) 
Now open excel Goto Tools>add in >browse (browse the file where you have stored the downloaded the file and select the file)
 press ok

 

 

Hi frenzz., am herewith attaching the file named inward.xla. Hope this will resolve ur prob..

save the inword.xla file in hard disk
 save it in a Folder permanently.(do not change the location of file after installation) 
Now open excel Goto Tools>add in >browse (browse the file where you have stored the downloaded the file and select the file)
 press ok 

 

and dont open that file., jus save it somewhere in ur hard disk...


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register