SPELL NUMBER IN ENGLISH i.e 1,000 RESULT IS ONE THOUSAND ONLY

i am searching a formula

e.g
i write any value like 1000
the result is come (One thousand Only)
i write any value like 50000
the result is come (fifty thousand Only)
the formula result vary when value change

Not a formula, but take a look at
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JAWAD CHOHAN" <JAWAD CHOHAN@discussions.microsoft.com> wrote in message
news:243AF398-4C44-4058-BFFB-12A43FEC7F13@microsoft.com...
> i am searching a formula
>
> e.g
> i write any value like 1000
> the result is come (One thousand Only)
> i write any value like 50000
> the result is come (fifty thousand Only)
> the formula result vary when value change
>