Md Mominul Islam | Software and Data Enginnering | SQL Server, .NET, Power BI, Azure Blog

while(!(succeed=try()));

LinkedIn Portfolio Banner

Latest

Home Top Ad

Responsive Ads Here

Post Top Ad

Responsive Ads Here

Wednesday, May 21, 2014

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

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




No comments:

Post a Comment

Thanks for your valuable comment...........
Md. Mominul Islam

Post Bottom Ad

Responsive Ads Here