Number Conversion

[Subhashis Bhowmick]

Sir,

I am using cheque print option in my office, during
entering payment fields, while I enter amount in currency
field, I want next cell will automatically take that
currency value to be converted in text format.

e.g. Currency: 42,530/-
Text Amount: Forth Two Thousand Five Hundred and Thirty
Only.

So if it is possibel in MS Excel 2000 or 97 or in XP. It
can help me out.

Plese mail me in my official mail ID.

Thank You,

Subhashis Bhowmick
Nagpur
India.

 

[Frank Kabel]

Hi
if you want to convert a number like 100 to something
like 'one
hundred' use one of the following macros/procedures

MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-
US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-
US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task
(for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods