Sir ,

How can we change numericals (Nos.)into Alphabets(Words)

Best Regards

Hi,

Take a look at the code in this link and modify according to your needs if
you need to.

http://www.ozgrid.com/VBA/ValueToWords.htm


--
Hope that helps.

Vergel Adriano


"ZEESHAN ANIS" wrote:

Sir ,

How can we change numericals (Nos.)into Alphabets(Words)

Best Regards

Hi Zeeshan,

You could download Laurent Longre's MoreFunc addin which is freely
downloadable at:

http://xcell05.free.fr/

The addin includes the NBTEXT function which converts a positive number into
spelled-out text (supports 13 languages).

Also see:
http://support.microsoft.com/default...b;en-us;213360
'How to convert a numeric value into English words in Excel'

and
http://support.microsoft.com/?scid=kb;en-us;259663
'How To Convert Currency or Numbers into English Words'


---
Regards,
Norman




"ZEESHAN ANIS" wrote in message
...
Sir ,

How can we change numericals (Nos.)into Alphabets(Words)

Best Regards