Number convert in to text ?

[Guest]

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)