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!
 
Top