Is there a function to change a number to text?

P

psdunlavy

I am trying to find a function that will convert numbers to text. Fo
example: the function will convert $567.87 to Five Hundred Sixty Seve
and 87/100's. Anybody know how to do this
 
D

dominicb

Good evening psdunlavy

There seems to be quite a demand for this type of function, although
Excel doesn't actually do it as a native function. Some add-ins are
available that once installed will do this (amongst other things) - to
receive my add-in (free to anyone who e-mails me), with instructions on
how to use the function, please send an e-mail to
[email protected].

HTH

DominicB
 
Top