Spell number

[vishu]

My question is simple. If i type number in Excel, that should spell the
number in another cell. For eg: If i type 252 in one cell, result should be "
Two hundred and Fifty two". Please let me know the formula for this.

 

[Bernard Liengme]

There is a macro for this on the Microsoft website.
OR do a Google Group search for previous answers to this question
best wishes

 

[vishu]

Can you please give me macro for this.....please help me...

 

[garfield-n-odie]

See http://support.microsoft.com/?kbid=213360 "How to convert a numeric
value into English words in Excel".