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 ,
"Goda" 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 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 ,
"Goda" 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)