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

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

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

See:

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

"Baala" wrote:

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

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

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