writting a number in letter

  • Thread starter Thread starter memento
  • Start date Start date
M

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
 
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 said:
Frank,

In the current version of morefunc (3.2.?), do you know how to get NBTEXT to
work with Excel 2002 SP3 without crashing?
Click to expand...
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
 
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 :-)
Click to expand...

Thank you for that information, Frank.
So unfortunately no solution from me...
Click to expand...

:-((
--ron
 
Back
Top