Thread: convert number to text and format it.

Hi,
I need to convert numbers into text e.i. 150 - one hundred fifty, and I
would like to know how to format it. If I need the numbers to be written in a
different language (e.i.Polish)

You'll need to use a macro. See

http://www.mvps.org/dmcritchie/excel...numberstowords

for some references to routines you can adapt.

In article <A843A346-621C-4A69-921A-D901F2B744F0@microsoft.com>,
"Goda" <Goda@discussions.microsoft.com> wrote:

> I need to convert numbers into text e.i. 150 - one hundred fifty, and I
> would like to know how to format it. If I need the numbers to be written in a
> different language (e.i.Polish)

Laurent Longre's MOREFUNC.XLL contains the NBTEXT Funtion in 13 different
languages.

Unfortunately Polish is not one of the 13.

http://longre.free.fr/english/index.html


Gord Dibben Excel MVP

On Mon, 07 Feb 2005 09:08:57 -0700, JE McGimpsey <jemcgimpsey@mvps.org> wrote:

>You'll need to use a macro. See
>
> http://www.mvps.org/dmcritchie/excel...numberstowords
>
>for some references to routines you can adapt.
>
>In article <A843A346-621C-4A69-921A-D901F2B744F0@microsoft.com>,
> "Goda" <Goda@discussions.microsoft.com> wrote:
>
>> I need to convert numbers into text e.i. 150 - one hundred fifty, and I
>> would like to know how to format it. If I need the numbers to be written in a
>> different language (e.i.Polish)