Function to convert Number into words

[mhshah]

I need to convert number values from a reference cell to correspondin
words for that number. Example : Cell A2 contains number 100 then th
function should be such that it converts it into words "One hundred

 

[jer]

This link should give you what you are looking for and
much more

http://www.ozgrid.com/VBA/Functions.htm#UDF15

 

[Ron Rosenfeld]

I need to convert number values from a reference cell to corresponding
words for that number. Example : Cell A2 contains number 100 then the
function should be such that it converts it into words "One hundred"

Download and install:

http://perso.wanadoo.fr/longre/excel/pages/Downloads.htm#Morefunc.xll.

and use the NUMTEXT function.


--ron