ConvNumberLetter
mario
-
HASSOUNI -
HASSOUNI -
Hello
of course I can't get it, sniff
to begin with,
I downloaded from: http://gerard.g.pagesperso-orange.fr/logexl_05.htm#Convertir%20les%20nombres%20en%20lettres
the problem,
I would like a number to convert into letters, for example: X€ or Y€ = Xeuro or Yeuro.
in the macro "function arguments", why "function arguments" i.e., =B3 proposes 52.12?
Convert numbers into letters:
No Excel function allows for the conversion of numbers into letters.
However, a macro has been created for this purpose and is called ConvNumberLetter.
To benefit from it, it must first be installed. It will then be available as a function.
1 - Installing the add-in: (THIS IS DONE)
Download the file NbLettre.xla and place it in the folder=
C:Documents and Settings / Your Name / Application Data / Microsoft/Complementary Macros.
Open Excel.
From the Tools menu / Complementary Macros… open the Add-in Macro dialog box.
In the window that has opened, check Nblettre (1) and click OK (2).
In case the Nblettre line does not appear, you should search for the NbLettre.xla file by clicking on Browse…
(3) and activate it.
This operation must be performed on each computer that will use the created macro.
2 - Using the ConvNumberLetter function: (THIS IS DONE)
As with a classic function, click on Insert Function.
In the Insert Function window select the Custom category (4) then the ConvNumberLetter function (5).
Click OK.
The function Arguments assistant window opens.
It has three argument areas to fill in as follows:
Number is the cell whose content is to be converted.
Currency (6) is:
0 none
1 Euro
2 Dollar $
Language (7) is:
0 French
1 Belgian
2 Swiss
(ERROR)
The appearance of the text resulting from this function cannot be changed.
For example, it is not possible to use uppercase letters.
Only the usual cell formatting (bold, italic…) is possible.
it seems to use the "Arial" font ?, anyway I used "Courier New" font in bold, italic.
To view the VBA code of the macro, press Alt+F11.
It is located in the Module ModNumLettre of VBAProject (NbLettre.xla) found in the Project Explorer,
on the left side of the window.
(ERROR)
so Alt+F11 "Microsoft Visual Basic-Workbook1" says: "(Name)VBAProject"
I don't understand anything about "....the whole located in the Project Explorer,"
I think I'm missing a macro, maybe? why isn't it working?
please, is there someone......WARNING I AM A TOTAL BEGINNER
Thank you.
of course I can't get it, sniff
to begin with,
I downloaded from: http://gerard.g.pagesperso-orange.fr/logexl_05.htm#Convertir%20les%20nombres%20en%20lettres
the problem,
I would like a number to convert into letters, for example: X€ or Y€ = Xeuro or Yeuro.
in the macro "function arguments", why "function arguments" i.e., =B3 proposes 52.12?
Convert numbers into letters:
No Excel function allows for the conversion of numbers into letters.
However, a macro has been created for this purpose and is called ConvNumberLetter.
To benefit from it, it must first be installed. It will then be available as a function.
1 - Installing the add-in: (THIS IS DONE)
Download the file NbLettre.xla and place it in the folder=
C:Documents and Settings / Your Name / Application Data / Microsoft/Complementary Macros.
Open Excel.
From the Tools menu / Complementary Macros… open the Add-in Macro dialog box.
In the window that has opened, check Nblettre (1) and click OK (2).
In case the Nblettre line does not appear, you should search for the NbLettre.xla file by clicking on Browse…
(3) and activate it.
This operation must be performed on each computer that will use the created macro.
2 - Using the ConvNumberLetter function: (THIS IS DONE)
As with a classic function, click on Insert Function.
In the Insert Function window select the Custom category (4) then the ConvNumberLetter function (5).
Click OK.
The function Arguments assistant window opens.
It has three argument areas to fill in as follows:
Number is the cell whose content is to be converted.
Currency (6) is:
0 none
1 Euro
2 Dollar $
Language (7) is:
0 French
1 Belgian
2 Swiss
(ERROR)
The appearance of the text resulting from this function cannot be changed.
For example, it is not possible to use uppercase letters.
Only the usual cell formatting (bold, italic…) is possible.
it seems to use the "Arial" font ?, anyway I used "Courier New" font in bold, italic.
To view the VBA code of the macro, press Alt+F11.
It is located in the Module ModNumLettre of VBAProject (NbLettre.xla) found in the Project Explorer,
on the left side of the window.
(ERROR)
so Alt+F11 "Microsoft Visual Basic-Workbook1" says: "(Name)VBAProject"
I don't understand anything about "....the whole located in the Project Explorer,"
I think I'm missing a macro, maybe? why isn't it working?
please, is there someone......WARNING I AM A TOTAL BEGINNER
Thank you.
Configuration: Windows XP Firefox 2.0.0.20
2 réponses
Hello,
I am a bit surprised because at home the function has 5 arguments.
'Number
' Currency=0 none
' =1 Euro €
' =2 Dollar $
' =3 €uro €
' Language=0 French
' =1 Belgium
' =2 Switzerland
' Case=0 Lowercase
' =1 Capitalize at the beginning of the sentence
' =2 Uppercase
' =3 Capitalize at the beginning of each word
' ZeroCent=0 Do not mention cents if they are equal to 0
' =1 Always mention cents
'***********
' Conversion limited to 999 999 999 999 999 or 9 999 999 999 999.99
if the number contains more than 2 decimals, it is rounded to 2 decimals
*****
The argument called "Case" would help you solve the uppercase problem.
Try adding the missing arguments or copy this formula:
=ConvNumberLetter(A7;1;2;1;0) with the number to be transformed in A7.
Good luck.
I am a bit surprised because at home the function has 5 arguments.
'Number
' Currency=0 none
' =1 Euro €
' =2 Dollar $
' =3 €uro €
' Language=0 French
' =1 Belgium
' =2 Switzerland
' Case=0 Lowercase
' =1 Capitalize at the beginning of the sentence
' =2 Uppercase
' =3 Capitalize at the beginning of each word
' ZeroCent=0 Do not mention cents if they are equal to 0
' =1 Always mention cents
'***********
' Conversion limited to 999 999 999 999 999 or 9 999 999 999 999.99
if the number contains more than 2 decimals, it is rounded to 2 decimals
*****
The argument called "Case" would help you solve the uppercase problem.
Try adding the missing arguments or copy this formula:
=ConvNumberLetter(A7;1;2;1;0) with the number to be transformed in A7.
Good luck.
I really liked your solution, but please provide me with this macro because mine is very old and doesn't recognize the other arguments.
Thank you.