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