How to convert Numbers into text

[Guest]

How to convert Number into Text e.g.

If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat
will be the formula for it?

 

[Rowan]

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

 

[Ron Rosenfeld]

On Thu, 15 Sep 2005 23:34:06 -0700, "S. Majid Hussain" <S. Majid

How to convert Number into Text e.g.

If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat
will be the formula for it?

1. Download and install Laurent Longre's free morefunc.xll from
http://xcell05.free.fr/

2. See the NBTEXT function
--ron

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

 

[Andy Wiggins]

This file might be a help:
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 the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.

 

[Guest]

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360