about converting numbers to text.

[Guest]

how can i convert a number to text number:
example:if we write (1000) or any number in any cell ,itwill be converted to
(one thousand) automatically.
??

 

[Nick Hodge]

Ahmad

Try here

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[R.VENKATARAMAN]

got to longre's page url is

http://xcell05.free.fr/

engligh version is also available.
the function is NBTEXT

he has given a number of functions. and you have to download thefile

 

[Guest]

Here is a user defined function:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
Perhaps it can be adapted.
Gary

 

[Nick Hodge]

Well Gary, that link looks familiar ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

It's amazing the information thats' contained within these threads that you
can find with a little searching...