How to Spell Number in English? I mean write 1 & see One?

[KVS]

I want to enter the number in one cell & see the English number in words in
the other formulated cell. What is the Forulla? how to write it?

 

[Jacob Skaria]

Please refer http://www.ozgrid.com/VBA/CurrencyToWords.htm

If this post helps click Yes

 

[Ashish Mathur]

Hi,

You can also download the xlmore func addin and then use the NBTEXT()
function.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com