SOLVED
Home

How to CONVERT Numbers to Words with Built-in Excel Formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-168783%22%20slang%3D%22en-US%22%3EHow%20to%20CONVERT%20Numbers%20to%20Words%20with%20Built-in%20Excel%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168783%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20writing%20cheque%20and%20invoices%20that%20must%20have%20the%20dollar%20amounts%20typed%20in%20words%20and%20it%20is%20hectic%20to%20type%20the%20numbers%20and%20then%20type%20words%20manually.%26nbsp%3BFor%20example%26nbsp%3B%24541%2C125.57%26nbsp%3B%20should%20convert%20to%26nbsp%3Bfive%20hundred%20forty-one%20thousand%20one%20hundred%20twenty-five%20Dollars%20and%20fifty-seven%20Cents%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20cannot%20use%20Macros%2FVBA%2C%20the%20only%20solution%20to%20work%20for%20me%20is%20built-in%20Excel%20formula%20or%20anything%20that%20would%20not%20use%20Macros.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-168783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389235%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20CONVERT%20Numbers%20to%20Words%20with%20Built-in%20Excel%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389235%22%20slang%3D%22en-US%22%3E%3CP%3EBrilliant!%20Just%20replace%20Dollar%20to%20your%20own%20currency%20and%20you%20are%20good%20to%20go.%20This%20is%20amazing%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168814%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20CONVERT%20Numbers%20to%20Words%20with%20Built-in%20Excel%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168814%22%20slang%3D%22en-US%22%3EHaytham%2C%3CBR%20%2F%3EDue%20to%20corporate%20domain%20environment%20administration%20setting%2C%20macros%20are%20blocked%20by%20default%20in%20our%20office%20domain.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20got%20an%20excellent%20solution%20with%20built-in%20formulas%20provided%20by%20Jamil%20Mohammad.%20%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168810%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20CONVERT%20Numbers%20to%20Words%20with%20Built-in%20Excel%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168810%22%20slang%3D%22en-US%22%3EWow!%3CBR%20%2F%3E%3CBR%20%2F%3ETHANK%20YOU%20SO%20VERY%20MUCH!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168805%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20CONVERT%20Numbers%20to%20Words%20with%20Built-in%20Excel%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168805%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Flora%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20fact%2C%20there%20is%20no%26nbsp%3Bbuilt-in%20function%20to%20do%20that.%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20do%20not%20think%20this%20can%20easily%20be%20achieved%20using%20a%20formula.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBut%20always%20there%26nbsp%3Bis%20a%20solution%20with%20VBA%2FMacros.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EP%3CSPAN%3Elease%20let%20us%20know%20why%20you%20can%20not%20use%20the%20VBA%2FMacros%3F%3CBR%20%2F%3EIs%20it%20disabled%20on%20your%20computer%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168791%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20CONVERT%20Numbers%20to%20Words%20with%20Built-in%20Excel%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168791%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20seen%20this%20question%20quite%20often%2C%20from%20colleagues%2C%20Q%26amp%3BA%20forums%20etc%2C%20but%20while%20there%20were%20many%20UDF%20solutions%2C%20there%20wasn't%20any%20solution%20with%20Built-In%20Formula%20(at%20least%20not%20to%20my%20knowledge).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20lucked%20out%2C%20as%20I%20had%20already%20written%20this%20Formula%26nbsp%3Bcouple%20of%20years%20ago.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20is%20the%20formula.%26nbsp%3B%20I%20have%20also%20uploaded%20the%20file%20with%20formula.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20only%20has%20one%20limitation%2C%20It%20cannot%20convert%20more%20than%20number%26nbsp%3B%20%24999%2C999%2C999%2C999.00%26nbsp%3B%26nbsp%3B%22Nine%20Hundred%20Ninety-Nine%20Billion%20Nine%20Hundred%20Ninety-Nine%20Million%20Nine%20Hundred%20Ninety-Nine%20Thousand%20Nine%20Hundred%20Ninety-Nine%20Dollars%20and%20Zero%20Cent%22%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20I%20think%20it%20will%20do%20the%20job%20for%20you.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F29853iCBDFA01EFD4D3AE5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22A.png%22%20title%3D%22A.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DIF(A1%26lt%3B%3D0%2C%22Referred%20Cell%20Must%20be%20Empty%22%2CIF(A1%26gt%3B10%5E12-0.01%2C%22Exceeds%20Maximum%20which%20is%20999999999999%22%2CTRIM(PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C1%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hundred%20%22%2C%22four%20hundred%20%22%2C%22five%20hundred%20%22%2C%22six%20hundred%20%22%2C%22seven%20hundred%20%22%2C%22eight%20hundred%20%22%2C%22nine%20hundred%20%22)%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C2%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C3%2C1)%2B1%2C%22ten%22%2C%22eleven%22%2C%22twelve%22%2C%22thirteen%22%2C%22fourteen%22%2C%22fifteen%22%2C%22sixteen%22%2C%22seventeen%22%2C%22eighteen%22%2C%22nineteen%22)%2C%22twenty%22%2C%22thirty%22%2C%22forty%22%2C%22fifty%22%2C%22sixty%22%2C%22seventy%22%2C%22eighty%22%2C%22ninety%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C2%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C3%2C1)%2B1%2C%22%22%2C%22-one%22%2C%22-two%22%2C%22-three%22%2C%22-four%22%2C%22-five%22%2C%22-six%22%2C%22-seven%22%2C%22-eight%22%2C%22-nine%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C2%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C3%2C1)%2B1%2C%22%22%2C%22one%22%2C%22two%22%2C%22three%22%2C%22four%22%2C%22five%22%2C%22six%22%2C%22seven%22%2C%22eight%22%2C%22nine%22)%2C%22%22))%2CIF(A1%26gt%3B%3D10%5E9%2C%22%20billion%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C4%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hu%0Andred%20%22%2C%22four%20hundred%20%22%2C%22five%20hundred%20%22%2C%22six%20hundred%20%22%2C%22seven%20hundred%20%22%2C%22eight%20hundred%20%22%2C%22nine%20hundred%20%22)%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C5%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C6%2C1)%2B1%2C%22ten%22%2C%22eleven%22%2C%22twelve%22%2C%22thirteen%22%2C%22fourteen%22%2C%22fifteen%22%2C%22sixteen%22%2C%22seventeen%22%2C%22eighteen%22%2C%22nineteen%22)%2C%22twenty%22%2C%22thirty%22%2C%22forty%22%2C%22fifty%22%2C%22sixty%22%2C%22seventy%22%2C%22eighty%22%2C%22ninety%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C5%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C6%2C1)%2B1%2C%22%22%2C%22-one%22%2C%22-two%22%2C%22-three%22%2C%22-four%22%2C%22-five%22%2C%22-six%22%2C%22-seven%22%2C%22-eight%22%2C%22-nine%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C5%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C6%2C1)%2B1%2C%22%22%2C%22one%22%2C%22two%22%2C%22three%22%2C%22four%22%2C%22five%22%2C%22six%22%2C%22seven%22%2C%22eight%22%2C%22nine%22)%2C%22%22))%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C4%2C3))%26gt%3B0%2C%22%20million%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C7%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hundred%20%22%2C%22four%20hundred%20%22%2C%22five%20hundred%20%22%2C%22six%20hundred%20%22%2C%22seven%20hundred%20%22%2C%22eight%20hundred%20%22%2C%22nine%20hundred%20%22)%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C8%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C%0A12))%2C9%2C1)%2B1%2C%22ten%22%2C%22eleven%22%2C%22twelve%22%2C%22thirteen%22%2C%22fourteen%22%2C%22fifteen%22%2C%22sixteen%22%2C%22seventeen%22%2C%22eighteen%22%2C%22nineteen%22)%2C%22twenty%22%2C%22thirty%22%2C%22forty%22%2C%22fifty%22%2C%22sixty%22%2C%22seventy%22%2C%22eighty%22%2C%22ninety%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C8%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C9%2C1)%2B1%2C%22%22%2C%22-one%22%2C%22-two%22%2C%22-three%22%2C%22-four%22%2C%22-five%22%2C%22-six%22%2C%22-seven%22%2C%22-eight%22%2C%22-nine%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C8%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C9%2C1)%2B1%2C%22%22%2C%22one%22%2C%22two%22%2C%22three%22%2C%22four%22%2C%22five%22%2C%22six%22%2C%22seven%22%2C%22eight%22%2C%22nine%22)%2C%22%22))%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C7%2C3))%2C%22%20thousand%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C10%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hundred%20%22%2C%22four%20hundred%20%22%2C%22five%20hundred%20%22%2C%22six%20hundred%20%22%2C%22seven%20hundred%20%22%2C%22eight%20hundred%20%22%2C%22nine%20hundred%20%22)%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C11%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C12%2C1)%2B1%2C%22ten%22%2C%22eleven%22%2C%22twelve%22%2C%22thirteen%22%2C%22fourteen%22%2C%22fifteen%22%2C%22sixteen%22%2C%22seventeen%22%2C%22eighteen%22%2C%22nineteen%22)%2C%22twenty%22%2C%22thirty%22%2C%22forty%22%2C%22fifty%22%2C%22sixty%22%2C%22seventy%22%2C%22eighty%22%2C%22ninety%0A%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C11%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C12%2C1)%2B1%2C%22%22%2C%22-one%22%2C%22-two%22%2C%22-three%22%2C%22-four%22%2C%22-five%22%2C%22-six%22%2C%22-seven%22%2C%22-eight%22%2C%22-nine%22)%2CIF(VALUE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C11%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A1)%2CREPT(0%2C12))%2C12%2C1)%2B1%2C%22%22%2C%22one%22%2C%22two%22%2C%22three%22%2C%22four%22%2C%22five%22%2C%22six%22%2C%22seven%22%2C%22eight%22%2C%22nine%22)%2C%22%22)))%2C%22%20%22%2C%22%20%22)%26amp%3BIF(FLOOR(A1%2C1)%26gt%3B1%2C%22%20dollars%22%2C%22%20%22)%26amp%3BIF(AND(A1%26gt%3B%3D1%2CA1%26lt%3B2)%2C%22dollar%22%2C%22%22))%26amp%3B%22%20and%20%22%26amp%3BIF(ISERROR(FIND(%22.%22%2CA1))%2C%22Zero%20Cent%22%2CPROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2))%3D1%2CCHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2)%2C%22ten%22%2C%22twenty%22%2C%22thirty%22%2C%22forty%22%2C%22fifty%22%2C%22sixty%22%2C%22seventy%22%2C%22eighty%22%2C%22ninety%22)%26amp%3B%22%20cents%22%2C%22%22)%26amp%3BCONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2))%2CREPT(0%2C12))%2C11%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2))%2CREPT(0%2C12))%2C12%2C1)%2B1%2C%22ten%22%2C%22eleven%22%2C%22twelve%22%2C%22thirteen%22%2C%22fourteen%22%2C%22fifteen%22%2C%22sixteen%22%2C%22seventeen%22%2C%22eighteen%22%2C%22nineteen%22)%26amp%3B%22%20cents%22%2C%22twent%0Ay%22%2C%22thirty%22%2C%22forty%22%2C%22fifty%22%2C%22sixty%22%2C%22seventy%22%2C%22eighty%22%2C%22ninety%22)%2CIF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2))%2CREPT(0%2C12))%2C11%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2))%2CREPT(0%2C12))%2C12%2C1)%2B1%2C%22%22%2C%22-one%22%2C%22-two%22%2C%22-three%22%2C%22-four%22%2C%22-five%22%2C%22-six%22%2C%22-seven%22%2C%22-eight%22%2C%22-nine%22)%26amp%3B%22%20cents%22%2CIF(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2)%3D%2200%22%2C%22zero%20cent%22%2CIF(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2)%3D%2201%22%2C%22one%20cent%22%2CIF(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C1)%3D%220%22%2CCHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1%2C%22.%22%2CREPT(%22%20%22%2C255))%2C255%2C200))%2C2))%2CREPT(0%2C12))%2C12%2C1)%2B1%2C%22%22%2C%22one%22%2C%22two%22%2C%22three%22%2C%22four%22%2C%22five%22%2C%22six%22%2C%22seven%22%2C%22eight%22%2C%22nine%22)%26amp%3B%22%20cents%22%2C%22%22))))))))))%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Flora Sim
Occasional Contributor

I am writing cheque and invoices that must have the dollar amounts typed in words and it is hectic to type the numbers and then type words manually. For example $541,125.57  should convert to five hundred forty-one thousand one hundred twenty-five Dollars and fifty-seven Cents

 

I cannot use Macros/VBA, the only solution to work for me is built-in Excel formula or anything that would not use Macros.

 

Thanks.

5 Replies
Solution

I had seen this question quite often, from colleagues, Q&A forums etc, but while there were many UDF solutions, there wasn't any solution with Built-In Formula (at least not to my knowledge).  

You lucked out, as I had already written this Formula couple of years ago. 

 

Here is the formula.  I have also uploaded the file with formula.

 

It only has one limitation, It cannot convert more than number  $999,999,999,999.00  "Nine Hundred Ninety-Nine Billion Nine Hundred Ninety-Nine Million Nine Hundred Ninety-Nine Thousand Nine Hundred Ninety-Nine Dollars and Zero Cent"

 

But I think it will do the job for you.

A.png

 

=IF(A1<=0,"Referred Cell Must be Empty",IF(A1>10^12-0.01,"Exceeds Maximum which is 999999999999",TRIM(PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),1,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),3,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),3,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(A1>=10^9," billion ",""),CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),4,1)+1,"","one hundred ","two hundred ","three hu
ndred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),6,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),6,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),7,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),8,1)+1,"",CHOOSE(MID(TEXT(INT(A1),REPT(0,
12)),9,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),10,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),12,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety
"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A1),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(A1),REPT(0,12)),12,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(A1,1)>1," dollars"," ")&IF(AND(A1>=1,A1<2),"dollar",""))&" and "&IF(ISERROR(FIND(".",A1)),"Zero Cent",PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2),"ten","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety")&" cents","")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2)),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2)),REPT(0,12)),12,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen")&" cents","twent
y","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2)),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine")&" cents",IF(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2)="00","zero cent",IF(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2)="01","one cent",IF(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),1)="0",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255,200)),2)),REPT(0,12)),12,1)+1,"","one","two","three","four","five","six","seven","eight","nine")&" cents",""))))))))))

 

Hi Flora,

 

In fact, there is no built-in function to do that.

I do not think this can easily be achieved using a formula.

But always there is a solution with VBA/Macros.

 

Please let us know why you can not use the VBA/Macros?
Is it disabled on your computer?

Wow!

THANK YOU SO VERY MUCH!
Haytham,
Due to corporate domain environment administration setting, macros are blocked by default in our office domain.

I got an excellent solution with built-in formulas provided by Jamil Mohammad.
Thanks

Brilliant! Just replace Dollar to your own currency and you are good to go. This is amazing work.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies