how to get "123" as one hundred and twenty three in excel

[Guest]

how to get "123" as "one hundred and twenty three" in excel

i.e if in the cell "A1" I type 123

I need it to be converted as one hundred and twenty three in some other cell

 

[Guest]

See:

http://www.xldynamic.com/source/xld.xlFAQ0004.html

 

[bplumhoff]

Hello,

I suggest to take my function SpellNumber from
http://www.sulprobil.com/html/spellnumber.html:

=LEFT(spellnumber(A1),FIND(" Dollar",spellnumber(A1))-1)

HTH,
Bernd