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...b;en-us;213360

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Ahmad Al-Nahar" <AhmadAlNahar@discussions.microsoft.com> wrote in message
news:15A09D27-B13C-4E85-BDBE-1BD288A5A420@microsoft.com...
> 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.
> ??

[Gary Rowe]

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
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Ahmad Al-Nahar" <AhmadAlNahar@discussions.microsoft.com> wrote in message
> news:15A09D27-B13C-4E85-BDBE-1BD288A5A420@microsoft.com...
> > 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]

Well Gary, that link looks familiar ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Gary Rowe" <GaryRowe@discussions.microsoft.com> wrote in message
news:4D4F8F36-5117-47A9-86E3-D87567557B98@microsoft.com...
> 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
>> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>> "Ahmad Al-Nahar" <AhmadAlNahar@discussions.microsoft.com> wrote in
>> message
>> news:15A09D27-B13C-4E85-BDBE-1BD288A5A420@microsoft.com...
>> > 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.
>> > ??
>>
>>
>>

[Gary Rowe]

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
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Gary Rowe" <GaryRowe@discussions.microsoft.com> wrote in message
> news:4D4F8F36-5117-47A9-86E3-D87567557B98@microsoft.com...
> > 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
> >> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >>
> >>
> >> "Ahmad Al-Nahar" <AhmadAlNahar@discussions.microsoft.com> wrote in
> >> message
> >> news:15A09D27-B13C-4E85-BDBE-1BD288A5A420@microsoft.com...
> >> > 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.
> >> > ??
> >>
> >>
> >>
>
>
>

[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


Ahmad Al-Nahar <AhmadAlNahar@discussions.microsoft.com> wrote in message
news:15A09D27-B13C-4E85-BDBE-1BD288A5A420@microsoft.com...
> 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.
> ??