convert number in cell to text in another cell

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace values with text 1
convert 3
Changing $ format to a written format 2
How to convert a ($200) cell to a written amount(Two hundred doll 2
Convert Numbers to Text 2
convert figures into words on Microsft Excel 3
Convert number to word in indian currency 2
numbertowords 2

Top