Conversion from currency value to currency text format

[gdselva]

Hi,

I have one question.

i.e.

Suppose I am entering the value in the Cell A1,

Input:
A1 contains 63,653

Output B1:
I need the output in B1 cell.

i.e.

Sixty Three Thousand six hundered and fifty three only.

The Conversion range from 0 to Millions.

Do you have any idea, how to do this through Formulas or VBA Macros.


Thanks,
Selvam

 

[Frank Kabel]

Hi
there're some macros/procedures to convert numbers to text. e.g.
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

 

[gdselva]

Thanks Frank

I will see and get back to you.


regards,

Selvam