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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Syed Saif" <Syed wrote in message
...
Pls add the facility in Excel whenever we type figure like 5000 a1 column
so
in a2 column(already selected for wordings) alphabetical statement type as
five thousand only. if we type 1500 in b1, b21\4000 or we sum/total figure
from a1 to a20 then in a21 then the words five hundred and fifty thousand
will type in selected column. already selected column. Liek cheque book.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...el.programming