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 :
0 comments:
Post a Comment