Hi
there're some macros/procedures to convert numbers to text. e.g.
MS Knowledge Base:
http://support.microsoft.com/default...B;EN-US;213360
http://support.microsoft.com/default...;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/...s/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods
--
Regards
Frank Kabel
Frankfurt, Germany
"gdselva " schrieb im
Newsbeitrag ...
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 K
---
Message posted from http://www.ExcelForum.com/