Wednesday, May 21, 2014
0 comments

How to convert a numeric value into English words in Excel 2007 and 2013

11:28 AM

Converting a numeric value into words in Excel 2007 and 2013


For 2007:


1. Download Add Ins from here:  https://www.dropbox.com/s/dse6hogv6nrt73t/spell2007.xlam
2. Put the Add Ins(.xalm file) to this Location :

C:\Program Files ( Or Program Files X 86)\Microsoft Office\ Office12\Library


 

3. Now go to  'Excel Option' from Office Icon  then click to 'Add-Ins Select' then  then click on Go Button at bottom.



4.  Click on OK after select the copied file(Spell2007 )



5. Now write formula as =spellnumber(cell)

 



Finish

For 2013


Download Add Ins fro  here : https://www.dropbox.com/s/cuqm9tyaqmapntd/spell2013.xlam
2. Put the Add Ins(.xalm file) to this Location :

C:\Program Files ( Or Program Files X 86)\Microsoft Office\ Office15\Library

then follow these steps: 



Now go to  'Excel Option' from Office Icon  then click to 'Add-Ins Select' then  then click on Go Button at bottom.


Now File --> Excel Option --> Customize Ribbon --> from  Main Tab check to  Developer and then click to OK .






From Developer tab click to Add-Ins then open click Add-Ins option .




Browsing  ‍'spell2013'  file then click OK after selecting.





 

Now check the spell2013 file and click OK




Now write formula on excel sheet as :





Finish




0 comments:

 
Toggle Footer