How to convert or express numeric value in words

[Vijay V Palakkal]

How one can convert or express a numeric value in words?
Suppose a numeric value of 30 is to be express in word
like Thirty.

Thanx

 

[Andy B]

Vijay

Here are two postings from a similar question from the last day or so:

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

http://www.barasch.com/excel/numb2words.htm

If you try searching Google first, you'll probably find the answer quicker!!

Andy.

 

[Orlando Magalhães Filho]

Hi Vijay V Palakkal,

Look for "VBA spell numbers function" at this site:
http://cpap.com.br/orlando

The code spells number with or without unit as argument and it spells
fraction part in three ways.


HTH