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

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

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 wrote in message
...
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