MS Excel 2000 Formula

[Subhashis Bhowmick]

Sir,

Can you help me in an excel formula, which will convert a
numeric cell value with its text formation.

e.g. 2134 gets change in another cell by Two Thousand One
Hundred And Thirty Four Only.

If you help in this regard, this will help me allot.

Thanks for your valuable time.

Regards,

 

[Rob van Gelder]

Take a look at VBnet
http://vbnet.mvps.org/code/helpers/numbertotext.htm

 

[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

 

[Bob Phillips]

Hi Subhashis,

There is no Excel function that will do this. You can either build your own
this article gives a steer,

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL :

http://longre.free.fr/english/index.html

This utility has lots of functions including a Numbers to Words Function
(multi-lingual).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)