Spell number
 

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.

There is a macro for this on the Microsoft website.
OR do a Google Group search for previous answers to this question
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

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

"vishu" wrote:

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.

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

vishu wrote:
Can you please give me macro for this.....please help me...

"vishu" wrote:


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.