How to convert Numbers into text

[S. Majid Hussain]

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...b;en-us;213360

S. Majid Hussain wrote:
> 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?
>

[Ron Rosenfeld]

On Thu, 15 Sep 2005 23:34:06 -0700, "S. Majid Hussain" <S. Majid
[email protected]> wrote:

>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

--
HTH

Bob Phillips

"S. Majid Hussain" <S. Majid [email protected]> wrote in
message news:[email protected]...
> 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?
>

[Andy Wiggins]

This file might be a help:
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 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.


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"S. Majid Hussain" <S. Majid [email protected]> wrote in
message news:[email protected]...
> 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?
>

[Anil-HML]

"Rowan" wrote:

> http://support.microsoft.com/default...b;en-us;213360
>
> S. Majid Hussain wrote:
> > 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?
> >
>