writting a number in letter

[memento]

Hello,

I would like to know if there is a function which writes a number i
letter. For exemple :

"1521" in "Thousand Five hundred and one"

Note : I woul like to have it written in French

Thanks for your help

 

[Frank Kabel]

Hi
there're some macros/procedures to convert numbers to text. e.g.
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods

 

[Ron Rosenfeld]

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

Frank,

In the current version of morefunc (3.2.?), do you know how to get NBTEXT to
work with Excel 2002 SP3 without crashing?


--ron

 

[Frank Kabel]

Frank,

In the current version of morefunc (3.2.?), do you know how to get NBTEXT to
work with Excel 2002 SP3 without crashing?

Hi Ron

I heard that some (many) people have probelms with this function
NBTEXT. For me its works on two different systems without a probelm
(Excel 97 English, Excel 2003 German). But AFAIK Launret is working on
a new release and I think he is already aware of this problem

So unfortunately no solution from me...

Frank

 

[Ron Rosenfeld]

I heard that some (many) people have probelms with this function
NBTEXT. For me its works on two different systems without a probelm
(Excel 97 English, Excel 2003 German). But AFAIK Launret is working on
a new release and I think he is already aware of this problem

Thank you for that information, Frank.

So unfortunately no solution from me...

:-((
--ron