Number convert in to text ?

[Shah]

Dear,
In Cell A1 i wirte 1, B1 gave me One, in A2, 2 then B2 gave me Two upto
................1000=Thousand
Thanks

[daddylonglegs]

If you want to do this with a formula you can download the MOREFUNC addin and use the NBTEXT function, then you just need

=NBTEXT(A1)

MOREFUNC addin is free, look here

http://www.rhdatasolutions.com/morefunc/

otherwise you need to use VBA

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Shah" <[email protected]> wrote in message
news:[email protected]...
> Dear,
> In Cell A1 i wirte 1, B1 gave me One, in A2, 2 then B2 gave me Two upto
> ...............1000=Thousand
> Thanks