about converting numbers to text.
 

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.
??

Ahmad

Try here

http://support.microsoft.com/default...b;en-us;213360

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ahmad Al-Nahar" wrote in message
...
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.
??

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


Ahmad Al-Nahar wrote in message
...
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.
??

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


"Nick Hodge" wrote:

Ahmad

Try here

http://support.microsoft.com/default...b;en-us;213360

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ahmad Al-Nahar" wrote in message
...
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.
??

Well Gary, that link looks familiar ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Gary Rowe" wrote in message
...
Here is a user defined function:
http://support.microsoft.com/default...b;en-us;213360
Perhaps it can be adapted.
Gary


"Nick Hodge" wrote:

Ahmad

Try here

http://support.microsoft.com/default...b;en-us;213360

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ahmad Al-Nahar" wrote in
message
...
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.
??

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

"Nick Hodge" wrote:

Well Gary, that link looks familiar ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Gary Rowe" wrote in message
...
Here is a user defined function:
http://support.microsoft.com/default...b;en-us;213360
Perhaps it can be adapted.
Gary


"Nick Hodge" wrote:

Ahmad

Try here

http://support.microsoft.com/default...b;en-us;213360

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ahmad Al-Nahar" wrote in
message
...
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.
??