about converting numbers to text.

[Ahmad Al-Nahar]

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
[email protected]

 

[Gary Rowe]

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
[email protected]

 

[Gary Rowe]

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