Figures To Words As Discussed By Amit - TXT Download

hiyamedia

Press ALT+F11 on Excel then goto Modules below on left and paste the notepad text attached here. Save, close and come back to excel. then in formula for cell type =ntow(cellreferance) [e.g. =ntow(A2) or = ntow(4168 ).
Thats it.

1 Attachment(s) [Login To View]

jalasayanan

This is very good.
I used to write a code using Hlookup, but this is more convenient
Hats off.

mdm_580@yahoo.co.in

Sorry, when using this ntow this command, these command only using particular Excel Sheet, When Open New Files, This Command Not Be Run, Pl suggest.

hiyamedia

The script has to be in your modules to enable you to use ntow. The entire script is needed to function. ntow just triggers the script in the modules to make calculations for you and return the value in words. Hope its clear

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute