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

Hi Sayed,

You could download Laurent Longre's MoreFunc addin which is freely
downloadable at:

http://xcell05.free.fr/

The addin includes the NBTEXT function which converts a positive number into
spelled-out text (supports 13 languages).

Also see:
http://support.microsoft.com/default...b;en-us;213360
'How to convert a numeric value into English words in Excel'

and
http://support.microsoft.com/?scid=kb;en-us;259663
'How To Convert Currency or Numbers into English Words'

In the latter cases, if you are not familiar with macros, you may wish to
visit David McRitchie's 'Getting Started With Macros And User Defined
Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



---
Regards,
Norman


"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

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