convert number in cell to text in another cell

B

Bill

I'm trying to take a number shown in one cell and show it in text in another
cell for example $300.50 is Three hundred dollars and fifty cents.
 
R

Ron Rosenfeld

I'm trying to take a number shown in one cell and show it in text in another
cell for example $300.50 is Three hundred dollars and fifty cents.
Click to expand...

Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

Then use the NBTEXT function.

=NBTEXT(A1,2,1,"dollar and!","dollars and","cent!","cents")


--ron
 
Top