convert numbers to words

R

reza

Hi all,

simple question, how to convert number to words.
ex. $ 10,000 ==> ten thousand dollars

thanks
 
L

LeighH

I used the Reza site to get the formula to insert into my form. We are
making a check form that will pull the number from one portion of the check &
convert it into a written out dollar amount. The pertinent "pull from" cell
is C4. I've inserted the formula shown below into my form in the appropriate
location.

=SpellNumber(C4)

I had previously formatted the cell for "text." Now it only shows the
formula typed out. What do I need to format the cell as in order to get
words? (i.e. Thirty-two dollars and fifteen cents, etc.)

Thanks for your help!
 

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

Top