I sharing a simple solution to convert number to words in excel.
For this download the zip file from following link and extract it After this you will get a file with name 'module'.
Next step: open excel and press alt + F11. now you will get a new window with title like "Microsoft Visual basic". then click 'File' menu and choose 'import file' and then choose 'module' file (extracted from zip file).
then close new window and return to excel.
Type a number in cell.then click on other cell and type =spellcurr(#cellid)
this will show your number in words.
Eg:
=spellcurr(A4)
Hope this help you...
File download
For this download the zip file from following link and extract it After this you will get a file with name 'module'.
Next step: open excel and press alt + F11. now you will get a new window with title like "Microsoft Visual basic". then click 'File' menu and choose 'import file' and then choose 'module' file (extracted from zip file).
then close new window and return to excel.
Type a number in cell.then click on other cell and type =spellcurr(#cellid)
this will show your number in words.
Eg:
=spellcurr(A4)
Hope this help you...
File download
No comments:
Post a Comment