Number convert in to text ?
 

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

Number convert in to text ?
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503754

Number convert in to text ?
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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