convert numbers to words
 

Hi all,

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

thanks

convert numbers to words
 

hi
see this site....
http://support.microsoft.com/?kbid=213360
and this site....
http://www.sulprobil.com/html/spellnumber.html
and this site....
http://www.ozgrid.com/VBA/ValueToWords.htm

yeah....it can get complicated.
good luck.

regard
FSt1

"reza" wrote:

Hi all,

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

thanks

convert numbers to words
 

FSt1...

Thanks

"FSt1" wrote:

hi
see this site....
http://support.microsoft.com/?kbid=213360
and this site....
http://www.sulprobil.com/html/spellnumber.html
and this site....
http://www.ozgrid.com/VBA/ValueToWords.htm

yeah....it can get complicated.
good luck.

regard
FSt1

"reza" wrote:

Hi all,

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

thanks

convert numbers to words
 

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!


"FSt1" wrote:

hi
see this site....
http://support.microsoft.com/?kbid=213360
and this site....
http://www.sulprobil.com/html/spellnumber.html
and this site....
http://www.ozgrid.com/VBA/ValueToWords.htm

yeah....it can get complicated.
good luck.

regard
FSt1

"reza" wrote:

Hi all,

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

thanks

convert numbers to words
 

Your mistake is in formatting the cell as text. Format as General or
Number, then re-enter the formula.
I hope that you did remember to install the UDF for SpellNumber?
--
David Biddulph

"LeighH" wrote in message
...
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!


"FSt1" wrote:

hi
see this site....
http://support.microsoft.com/?kbid=213360
and this site....
http://www.sulprobil.com/html/spellnumber.html
and this site....
http://www.ozgrid.com/VBA/ValueToWords.htm

yeah....it can get complicated.
good luck.

regard
FSt1

"reza" wrote:

Hi all,

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

thanks