Convert numbers into words

Question

Hello

Please how to Convert numbers into words in order to use it in the Invoices.

I already used The NBTEXTE it is an Morefunc add-ins function, But now Microsoft does not have a version of this add-ins which will work with OfficeO365. It is not possible to have that product.

So please, I would really appreciate if someone could help us

Yours faithfully

Mokrane.A

Answer 1

RE: "how to Convert numbers into words in order to use it in the Invoices."

The Num2Text function is part of the free "Custom_Functions" Excel add-in.

(20+ new functions that work exactly like the built-in functions)

Download from OneDrive...

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

Also download the Word.docx examples file.

Nothing Left to Lose

Answer 2

=webservice("http://a.anyoupin.cn/eh3/?numToFrWord~24,931.16")

try this formula.

Answer 3

Hi Mokrane.A ,

Please how to Convert numbers into words in order to use it in the Invoices.

I already used The NBTEXTE it is an Morefunc add-ins function, But now Microsoft does not have a version of this add-ins which will work with OfficeO365. It is not possible to have that product.

So please, I would really appreciate if someone could help us

With Excel 365 / Excel 2021, try the formula:

=LET(

Denom, {" Million, ";" Thousand ";" Dollars ";" Cents"},

Nums, {"","One","Two","Three","Four","Five","Six","Seven","Eight"," Nine"},

Teens, {"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},

Tens, {"","Ten","Twenty","Thirty","Forty","Fifty","Sixty","Seventy","Eighty","Ninety"},

grp, {0;1;2;3},

LET(

N, SUBSTITUTE( TEXT( A1, REPT(0,9)&".00" ),".","0"),

H, VALUE( MID( N, 3*grp+1, 1) ), T, VALUE( MID( N, 3*grp+2, 1) ),

U, VALUE( MID( N, 3*grp+3, 1) ),

Htxt, IF( H, INDEX( Nums, H+1 ) & " Hundred ", "" ),

Ttxt, IF( T>1, INDEX( Tens, T+1 ) & IF( U>0, "-", "" ), " " ),

Utxt, IF( (T+U), IF( T=1, INDEX( Teens, U+1 ), INDEX(Nums, U+1 ) ) ),

CONCAT( IF( H+T+U, Htxt & Ttxt & Utxt & Denom, "" ) )

)

)

For more information, see https://www.excel-exercise.com/convert-number-to-words-in-excel/

===

Regards,

Norman

Answer 4

Hello

thank you for your reply really appreciate

I try it but not the result that I want

Please find below the NBTEXTE function result in french

$       24,931.16

                         ****                             

VINGT-QUATRE MILLE NEUF CENT TRENTE ET UN DOLLARS SEIZE CENT

Answer 5

Hi Mokrane,

Hello

thank you for your reply really appreciate

I try it but not the result that I want

Please find below the NBTEXTE function result in french

$       24,931.16

VINGT-QUATRE MILLE NEUF CENT TRENTE ET UN DOLLARS SEIZE CENT

For use with a French version of Excel. you would need to translate the various unit names and modify the decimal separator.

Hence, with the comma as your decimal separator, try the formula:

=LET(

Denom; {" Million, ";" Mille ";" Dollar ";" Cents"};

Nums; {"""Un""Deux""Trois""Quatre""Cinq""Six""Sept""Huit""Neuf"};

Teens; {"Dix""Onze""Douze""Treize""Quatorze""Quinze""Seize""Dix-sept""Dix-huit""Dix-neuf"};

Tens; {"""Dix""Vingt""Trente""Quarante""Cinquante""Soixante""Soixante-dix""Quatre-vingt""Quatre-vingt-dix"};

grp; {0;1;2;3};

LET(

N; SUBSTITUTE( TEXT( A1; REPT(0;9)&",00" );",";"0");

H; VALUE( MID( N; 3*grp+1; 1) ); T; VALUE( MID( N; 3*grp+2; 1) );

U; VALUE( MID( N; 3*grp+3; 1) );

Htxt; IF( H; INDEX( Nums; H+1 ) & " Cent "; "" );

Ttxt; IF( T>1; INDEX( Tens; T+1 ) & IF( U>0; "-"; "" ); " " );

Utxt; IF( (T+U); IF( T=1; INDEX( Teens; U+1 ); INDEX(Nums; U+1 ) ) );

CONCAT( IF( H+T+U; Htxt & Ttxt & Utxt & Denom; "" ) )

)

)

===

Regards,

Norman