SOLVED
Home

Number to word convertion in excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-184871%22%20slang%3D%22en-US%22%3ENumber%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184871%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20a%20way%20to%20convert%20numbers(which%20inside%20a%20single%20cell)%20into%20words.%3C%2FP%3E%3CP%3EI%20search%20the%20net%20and%20found%20this%20code%3A%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3EOption%20Explicit%3CBR%20%2F%3EPublic%20Numbers%20As%20Variant%2C%20Tens%20As%20Variant%3C%2FP%3E%3CP%3ESub%20SetNums()%3CBR%20%2F%3ENumbers%20%3D%20Array(%22%22%2C%20%22One%22%2C%20%22Two%22%2C%20%22Three%22%2C%20%22Four%22%2C%20%22Five%22%2C%20%22Six%22%2C%20%22Seven%22%2C%20%22Eight%22%2C%20%22Nine%22%2C%20%22Ten%22%2C%20%22Eleven%22%2C%20%22Twelve%22%2C%20%22Thirteen%22%2C%20%22Fourteen%22%2C%20%22Fifteen%22%2C%20%22Sixteen%22%2C%20%22Seventeen%22%2C%20%22Eighteen%22%2C%20%22Nineteen%22)%3CBR%20%2F%3ETens%20%3D%20Array(%22%22%2C%20%22%22%2C%20%22Twenty%22%2C%20%22Thirty%22%2C%20%22Forty%22%2C%20%22Fifty%22%2C%20%22Sixty%22%2C%20%22Seventy%22%2C%20%22Eighty%22%2C%20%22Ninety%22)%3CBR%20%2F%3EEnd%20Sub%3C%2FP%3E%3CP%3EFunction%20WordNum(MyNumber%20As%20Double)%20As%20String%3CBR%20%2F%3EDim%20DecimalPosition%20As%20Integer%2C%20ValNo%20As%20Variant%2C%20StrNo%20As%20String%3CBR%20%2F%3EDim%20NumStr%20As%20String%2C%20n%20As%20Integer%2C%20Temp1%20As%20String%2C%20Temp2%20As%20String%3CBR%20%2F%3E'%20This%20macro%20was%20written%20by%20Chris%20Mead%20-%20%3CA%20href%3D%22http%3A%2F%2Fwww.MeadInKent.co.uk%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.MeadInKent.co.uk%3C%2FA%3E%3C%2FP%3E%3CP%3EIf%20Abs(MyNumber)%20%26gt%3B%20999999999%20Then%3CBR%20%2F%3EWordNum%20%3D%20%22Value%20too%20large%22%3CBR%20%2F%3EExit%20Function%3CBR%20%2F%3EEnd%20If%3C%2FP%3E%3CP%3ESetNums%3C%2FP%3E%3CP%3E'%20String%20representation%20of%20amount%20(excl%20decimals)%3CBR%20%2F%3ENumStr%20%3D%20Right(%22000000000%22%20%26amp%3B%20Trim(Str(Int(Abs(MyNumber))))%2C%209)%3CBR%20%2F%3EValNo%20%3D%20Array(0%2C%20Val(Mid(NumStr%2C%201%2C%203))%2C%20Val(Mid(NumStr%2C%204%2C%203))%2C%20Val(Mid(NumStr%2C%207%2C%203)))%3C%2FP%3E%3CP%3EFor%20n%20%3D%203%20To%201%20Step%20-1%20'analyse%20the%20absolute%20number%20as%203%20sets%20of%203%20digits%3CBR%20%2F%3EStrNo%20%3D%20Format(ValNo(n)%2C%20%22000%22)%3C%2FP%3E%3CP%3EIf%20ValNo(n)%20%26gt%3B%200%20Then%3CBR%20%2F%3ETemp1%20%3D%20GetTens(Val(Right(StrNo%2C%202)))%3CBR%20%2F%3EIf%20Left(StrNo%2C%201)%20%26lt%3B%26gt%3B%20%220%22%20Then%3CBR%20%2F%3ETemp2%20%3D%20Numbers(Val(Left(StrNo%2C%201)))%20%26amp%3B%20%22%20hundred%22%3CBR%20%2F%3EIf%20Temp1%20%26lt%3B%26gt%3B%20%22%22%20Then%20Temp2%20%3D%20Temp2%20%26amp%3B%20%22%20%22%3CBR%20%2F%3EElse%3CBR%20%2F%3ETemp2%20%3D%20%22%22%3CBR%20%2F%3EEnd%20If%3C%2FP%3E%3CP%3EIf%20n%20%3D%203%20Then%3CBR%20%2F%3EIf%20Temp2%20%3D%20%22%22%20And%20ValNo(1)%20%2B%20ValNo(2)%20%26gt%3B%200%20Then%20Temp2%20%3D%20%22%20%22%3CBR%20%2F%3EWordNum%20%3D%20Trim(Temp2%20%26amp%3B%20Temp1)%3C%2FP%3E%3CP%3EEnd%20If%3CBR%20%2F%3EIf%20n%20%3D%202%20Then%20WordNum%20%3D%20Trim(Temp2%20%26amp%3B%20Temp1%20%26amp%3B%20%22%20thousand%20%22%20%26amp%3B%20WordNum)%3CBR%20%2F%3EIf%20n%20%3D%201%20Then%20WordNum%20%3D%20Trim(Temp2%20%26amp%3B%20Temp1%20%26amp%3B%20%22%20million%20%22%20%26amp%3B%20WordNum)%3C%2FP%3E%3CP%3EEnd%20If%3CBR%20%2F%3ENext%20n%3C%2FP%3E%3CP%3ENumStr%20%3D%20Trim(Str(Abs(MyNumber)))%3C%2FP%3E%3CP%3E'%20Values%20after%20the%20decimal%20place%3CBR%20%2F%3EDecimalPosition%20%3D%20InStr(NumStr%2C%20%22.%22)%3CBR%20%2F%3ENumbers(0)%20%3D%20%22%22%3CBR%20%2F%3EIf%20DecimalPosition%20%26gt%3B%200%20And%20DecimalPosition%20%26lt%3B%20Len(NumStr)%20Then%3CBR%20%2F%3ETemp1%20%3D%20%22%20%22%3CBR%20%2F%3EFor%20n%20%3D%20DecimalPosition%20%2B%201%20To%20Len(NumStr)%3CBR%20%2F%3ETemp1%20%3D%20Temp1%20%26amp%3B%20%22%20%22%20%26amp%3B%20Numbers(Val(Mid(NumStr%2C%20n%2C%201)))%3CBR%20%2F%3ENext%20n%3CBR%20%2F%3EWordNum%20%3D%20WordNum%20%26amp%3B%20%22%20and%22%20%26amp%3B%20Temp1%26nbsp%3B%26amp%3B%20%22%20Fils%22%3CBR%20%2F%3EEnd%20If%3C%2FP%3E%3CP%3EIf%20Len(WordNum)%20%3D%200%20Or%20Left(WordNum%2C%202)%20%3D%200%20Then%3CBR%20%2F%3EWordNum%20%3D%20%22Zero%22%20%26amp%3B%20WordNum%3CBR%20%2F%3EEnd%20If%3CBR%20%2F%3EEnd%20Function%3C%2FP%3E%3CP%3EFunction%20GetTens(TensNum%20As%20Integer)%20As%20String%3CBR%20%2F%3E'%20Converts%20a%20number%20from%200%20to%2099%20into%20text.%3CBR%20%2F%3EIf%20TensNum%20%26lt%3B%3D%2019%20Then%3CBR%20%2F%3EGetTens%20%3D%20Numbers(TensNum)%3CBR%20%2F%3EElse%3CBR%20%2F%3EDim%20MyNo%20As%20String%3CBR%20%2F%3EMyNo%20%3D%20Format(TensNum%2C%20%2200%22)%3CBR%20%2F%3EGetTens%20%3D%20Tens(Val(Left(MyNo%2C%201)))%20%26amp%3B%20%22%20%22%20%26amp%3B%20Numbers(Val(Right(MyNo%2C%201)))%3CBR%20%2F%3EEnd%20If%3CBR%20%2F%3EEnd%20Function%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3EBut%20after%20using%20the%20code%2C%20I%20still%20want%20some%20modification.%20This%20are%20the%20values%20of%20the%20cells(as%20per%20sample)%20that%20I%20want%20to%20convert%201st-123%2C456.789%2C%202nd-123%2C456.000%2C%203rd-0.789%3C%2FP%3E%3CP%3EThe%20module%20gives%20me%20output%20of%20the%20following%3A%3C%2FP%3E%3CP%3E1st%20%3D%20One%20hundred%20Twenty%20Three%20thousand%20Four%20hundred%20Fifty%20Six%20and%20Seven%20Eight%20Nine%3C%2FP%3E%3CP%3E2nd%20%3D%20One%20hundred%20Twenty%20Three%20thousand%20Four%20hundred%20Fifty%20Six%3C%2FP%3E%3CP%3E3rd%20%3D%20and%20seven%20Eight%20Nine%3C%2FP%3E%3CP%3E----------------------------------%3C%2FP%3E%3CP%3EWhat%20I%20want%20as%20outputs%20are%20the%20following%3A%3C%2FP%3E%3CP%3E1st%20%3D%26nbsp%3B%3CSPAN%3EOne%20hundred%20Twenty%20Three%20thousand%20Four%20hundred%20Fifty%20Six%20and%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3BSeven%20hundred%20Eighty%20Nine%20Fils%20Only%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2nd%20%3D%26nbsp%3BOne%20hundred%20Twenty%20Three%20thousand%20Four%20hundred%20Fifty%20Six%20Only%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E3rd%20%3D%26nbsp%3BSeven%20hundred%20Eighty%20Nine%26nbsp%3BFils%20Only%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E----------------------------------%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EWhat%20problems%20I'm%20with%3F%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E1st%20part%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20numbers%20after%20the%20decimal%20point(.)%20not%20converting%20as%20I%20want.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2nd%20part%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20I%20want%20it%20to%20show%20%22only%22%20in%20each%20end%20of%20the%20word%20converted.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E3rd%20part%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20%22and%22%20is%20showing.%20If%20the%20right%20side%20part%20is%20%3D0%2C%20I%20want%20the%20converted%20word%20only%26nbsp%3Bof%20the%20right%20side%20part.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EOverall%2C%20I%20tried%20to%20put%20the%20%22only%22%20and%20if%20appears%20in%20all%203cells%20but%20the%20problem%20also%20appears%20in%20the%201st%20part%20like%20this%3A%26nbsp%3BOne%20hundred%20Twenty%20Three%20thousand%20Four%20hundred%20Fifty%20Six%20Only%20and%26nbsp%3BSeven%20hundred%20Eighty%20Nine%20Fils%20Only.%20It%20shows%20the%20word%20%22only%22%20twice.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-------------------------------------------%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20help%20me%20with%20my%20issue.%20I'll%20wait%20for%20any%20response.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%20in%20advance.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-184871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219727%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219727%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jennifer%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ehere%20is%20the%20formula.%20also%20embedded%20it%20in%20the%20attached%20workbook.%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%20%22%2C%22%20%22)%26amp%3BIF(AND(A1%26gt%3B%3D1%2CA1%26lt%3B2)%2C%22%22%2C%22%22)))))%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219258%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219258%22%20slang%3D%22en-US%22%3E%3CP%3EJamil%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esorry%20to%20bother%20you%20but%20any%20luck%20updating%20this%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218963%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218963%22%20slang%3D%22en-US%22%3E%3CP%3ETHANK%20YOU!!!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218943%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218943%22%20slang%3D%22en-US%22%3EHi%20Jennifer%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYes%2C%20it%20is%20possible.%20Right%20now%20I%20am%20away%20from%20my%20desk%2C%20I%20will%20be%20home%20in%20couple%20of%20hours%20and%20I%20will%20write%20the%20modified%20formula%20here.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218911%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218911%22%20slang%3D%22en-US%22%3E%3CP%3EWould%20it%20be%20possible%20to%20modify%20this%20formula%20so%20the%20and%20only%20is%20eliminated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E358%20converts%20to%20Three%20Hundred%20Fifty-Eight%20and%20Only%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20only%20be%20working%20with%20whole%20numbers%20no%20decimals.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJennifer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218523%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218523%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20a%20posted%20conversation%20Jamil%20created%20this%20amazing%20formula%20to%20convert%20numbers%20their%20equivalent%20word.%20It%20work%20perfectly%2C%20however%20I%20just%20want%20to%20alter%20it%20slightly%20so%20it%20doesn't%20include%20and%20only%20at%20the%20end%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%20when%20I%20use%20the%20number%20358%20it%20converts%20the%20number%20to%20Three%20Hundred%20Fifty-Eight%20%3CSTRONG%3Eand%20Only.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3Ei%20just%20want%20it%20to%20read%20Three%20Hundred%20Fifty-Eight.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(A2%26lt%3B%3D0%2C%22Referred%20Cell%20Must%20be%20Empty%22%2CIF(A2%26gt%3B10%5E12-0.01%2C%22Exceeds%20Maximum%20which%20is%20999999999999.99%22%2CTRIM(PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C2%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C2%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C2%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2%26gt%3B%3D10%5E9%2C%22%20billion%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A2)%2CREPT(0%2C12))%2C4%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hu%3CBR%20%2F%3Endred%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(A2)%2CREPT(0%2C12))%2C5%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C5%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C5%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C4%2C3))%26gt%3B0%2C%22%20million%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C8%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%2CREPT(0%2C%3CBR%20%2F%3E12))%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(A2)%2CREPT(0%2C12))%2C8%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C8%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C7%2C3))%2C%22%20thousand%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C11%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%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%3CBR%20%2F%3E%22)%2CIF(VALUE(MID(TEXT(INT(A2)%2CREPT(0%2C12))%2C11%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C11%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2%2C1)%26gt%3B1%2C%22%20%22%2C%22%20%22)%26amp%3BIF(AND(A2%26gt%3B%3D1%2CA2%26lt%3B2)%2C%22%20%22%2C%22%22))%26amp%3B%22%20%3CSTRONG%3Eand%20%3C%2FSTRONG%3E%22%26amp%3BIF(ISERROR(FIND(%22.%22%2CA2))%2C%22%3CSTRONG%3EOnly%3C%2FSTRONG%3E%22%2CPROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C2%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C2%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C2%2C1))%3D0%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(A2%26gt%3B%3D10%5E9%2C%22%20billion%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C4%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hu%3CBR%20%2F%3Endred%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C5%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C5%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C5%2C1))%3D0%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C4%2C3))%26gt%3B0%2C%22%20million%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C8%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C%3CBR%20%2F%3E12))%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C8%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C8%2C1))%3D0%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C7%2C3))%2C%22%20thousand%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C11%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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%3CBR%20%2F%3E%22)%2CIF(VALUE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C11%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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))))))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189212%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189212%22%20slang%3D%22en-US%22%3EYou%20are%20most%20welcome!%20%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20your%20kind%20feedback.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188991%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188991%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20Mr.%20Mohammed%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20a%20hell%20of%20formula.%20I%20was%20able%20to%20check%20the%20formula%20and%20adjust%20some%20as%20per%20my%20concern%20and%20it%20worked!!%20Though%20it's%20really%20a%20hell%20long%20formula%2C%20it%20really%20gives%20me%20the%20exact%20output%20that%20I%20want!%20Very%20very%20much%20appreciated!%20Worth%20the%20wait.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain%2C%20THANK%20YOU%20so%20MUCH%20Sir!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-186442%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-186442%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Christoffer%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20one%20was%20a%20hell%20of%20a%20formula.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B2%20formula%20below%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(A2%26lt%3B%3D0%2C%22Referred%20Cell%20Must%20be%20Empty%22%2CIF(A2%26gt%3B10%5E12-0.01%2C%22Exceeds%20Maximum%20which%20is%20999999999999.99%22%2CTRIM(PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C2%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C2%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C2%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2%26gt%3B%3D10%5E9%2C%22%20billion%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A2)%2CREPT(0%2C12))%2C4%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hu%3CBR%20%2F%3Endred%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(A2)%2CREPT(0%2C12))%2C5%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C5%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C5%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C4%2C3))%26gt%3B0%2C%22%20million%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C8%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%2CREPT(0%2C%3CBR%20%2F%3E12))%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(A2)%2CREPT(0%2C12))%2C8%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C8%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C7%2C3))%2C%22%20thousand%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C11%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(INT(A2)%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%3CBR%20%2F%3E%22)%2CIF(VALUE(MID(TEXT(INT(A2)%2CREPT(0%2C12))%2C11%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(INT(A2)%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(A2)%2CREPT(0%2C12))%2C11%2C1))%3D0%2CCHOOSE(MID(TEXT(INT(A2)%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(A2%2C1)%26gt%3B1%2C%22%20%22%2C%22%20%22)%26amp%3BIF(AND(A2%26gt%3B%3D1%2CA2%26lt%3B2)%2C%22%20%22%2C%22%22))%26amp%3B%22%20and%20%22%26amp%3BIF(ISERROR(FIND(%22.%22%2CA2))%2C%22Only%22%2CPROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C2%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C2%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C2%2C1))%3D0%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(A2%26gt%3B%3D10%5E9%2C%22%20billion%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C4%2C1)%2B1%2C%22%22%2C%22one%20hundred%20%22%2C%22two%20hundred%20%22%2C%22three%20hu%3CBR%20%2F%3Endred%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C5%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C5%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C5%2C1))%3D0%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C4%2C3))%26gt%3B0%2C%22%20million%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C8%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C%3CBR%20%2F%3E12))%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C8%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C8%2C1))%3D0%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C7%2C3))%2C%22%20thousand%20%22%2C%22%22)%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C11%2C1)%2B1%2C%22%22%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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%3CBR%20%2F%3E%22)%2CIF(VALUE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C11%2C1))%26gt%3B1%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2CREPT(0%2C12))%2C11%2C1))%3D0%2CCHOOSE(MID(TEXT(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%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(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%2C1)%26gt%3B1%2C%22%20Fils%20Only%22%2C%22%20%22)%26amp%3BIF(AND(TEXT(MOD(A2%2C1)*1000%2C%22000%22)%26gt%3B%3D1%2CTEXT(MOD(A2%2C1)*1000%2C%22000%22)%26lt%3B2)%2C%22Fil%20Only%22%2C%22%22))))))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAND%20in%20C2%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(A2%26lt%3B1%2CSUBSTITUTE(B2%2C%22and%20%22%2C%22%20%22)%2CIF(ISERROR(FIND(%22.%22%2CA2))%2CSUBSTITUTE(B2%2C%22%20and%20%22%2C%22%20%22)%2CB2))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20see%20attached%20sample%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185491%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185491%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20that%20will%20be%20great%20Sir.%20I%20will%20happy%20to%20try%20it.%20How%20will%20I%20get%20that%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20Sir%20Jamil.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184925%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184925%22%20slang%3D%22en-US%22%3EI%20suggest%20you%20use%20built%20in%20formulas%20instead%20of%20user%20defined%20function.%20I%20have%20written%20a%20long%20formula%20that%20achieves%20converting%20numeric%20to%20words.%20Will%20it%20work%20for%20you%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-759773%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759773%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20tried%20this%20formula%20and%20it%20works%20great%2C%20thanks.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F24499%22%20target%3D%22_blank%22%3E%40Jamil%20Mohammad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-759930%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759930%22%20slang%3D%22en-US%22%3EYou%20must%20try%20my%20formula%2C%20too.%20View%20it%20in%20this%20link%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-NumToWords-Formula%2Fm-p%2F727433%23M33661%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-NumToWords-Formula%2Fm-p%2F727433%23M33661%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-763418%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20to%20word%20convertion%20in%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763418%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378020%22%20target%3D%22_blank%22%3E%40Louis_Arsenault%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20welcome%20Louis.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20feedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Christoffer Nucum
New Contributor

Good day,

 

I'm looking for a way to convert numbers(which inside a single cell) into words.

I search the net and found this code:

==============================================================

Option Explicit
Public Numbers As Variant, Tens As Variant

Sub SetNums()
Numbers = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen")
Tens = Array("", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")
End Sub

Function WordNum(MyNumber As Double) As String
Dim DecimalPosition As Integer, ValNo As Variant, StrNo As String
Dim NumStr As String, n As Integer, Temp1 As String, Temp2 As String
' This macro was written by Chris Mead - www.MeadInKent.co.uk

If Abs(MyNumber) > 999999999 Then
WordNum = "Value too large"
Exit Function
End If

SetNums

' String representation of amount (excl decimals)
NumStr = Right("000000000" & Trim(Str(Int(Abs(MyNumber)))), 9)
ValNo = Array(0, Val(Mid(NumStr, 1, 3)), Val(Mid(NumStr, 4, 3)), Val(Mid(NumStr, 7, 3)))

For n = 3 To 1 Step -1 'analyse the absolute number as 3 sets of 3 digits
StrNo = Format(ValNo(n), "000")

If ValNo(n) > 0 Then
Temp1 = GetTens(Val(Right(StrNo, 2)))
If Left(StrNo, 1) <> "0" Then
Temp2 = Numbers(Val(Left(StrNo, 1))) & " hundred"
If Temp1 <> "" Then Temp2 = Temp2 & " "
Else
Temp2 = ""
End If

If n = 3 Then
If Temp2 = "" And ValNo(1) + ValNo(2) > 0 Then Temp2 = " "
WordNum = Trim(Temp2 & Temp1)

End If
If n = 2 Then WordNum = Trim(Temp2 & Temp1 & " thousand " & WordNum)
If n = 1 Then WordNum = Trim(Temp2 & Temp1 & " million " & WordNum)

End If
Next n

NumStr = Trim(Str(Abs(MyNumber)))

' Values after the decimal place
DecimalPosition = InStr(NumStr, ".")
Numbers(0) = ""
If DecimalPosition > 0 And DecimalPosition < Len(NumStr) Then
Temp1 = " "
For n = DecimalPosition + 1 To Len(NumStr)
Temp1 = Temp1 & " " & Numbers(Val(Mid(NumStr, n, 1)))
Next n
WordNum = WordNum & " and" & Temp1 & " Fils"
End If

If Len(WordNum) = 0 Or Left(WordNum, 2) = 0 Then
WordNum = "Zero" & WordNum
End If
End Function

Function GetTens(TensNum As Integer) As String
' Converts a number from 0 to 99 into text.
If TensNum <= 19 Then
GetTens = Numbers(TensNum)
Else
Dim MyNo As String
MyNo = Format(TensNum, "00")
GetTens = Tens(Val(Left(MyNo, 1))) & " " & Numbers(Val(Right(MyNo, 1)))
End If
End Function

==============================================================

But after using the code, I still want some modification. This are the values of the cells(as per sample) that I want to convert 1st-123,456.789, 2nd-123,456.000, 3rd-0.789

The module gives me output of the following:

1st = One hundred Twenty Three thousand Four hundred Fifty Six and Seven Eight Nine

2nd = One hundred Twenty Three thousand Four hundred Fifty Six

3rd = and seven Eight Nine

----------------------------------

What I want as outputs are the following:

1st = One hundred Twenty Three thousand Four hundred Fifty Six and Seven hundred Eighty Nine Fils Only

2nd = One hundred Twenty Three thousand Four hundred Fifty Six Only

3rd = Seven hundred Eighty Nine Fils Only

----------------------------------

What problems I'm with?:

1st part

- numbers after the decimal point(.) not converting as I want.

2nd part

- I want it to show "only" in each end of the word converted.

3rd part

- "and" is showing. If the right side part is =0, I want the converted word only of the right side part.

Overall, I tried to put the "only" and if appears in all 3cells but the problem also appears in the 1st part like this: One hundred Twenty Three thousand Four hundred Fifty Six Only and Seven hundred Eighty Nine Fils Only. It shows the word "only" twice.

-------------------------------------------

Please help me with my issue. I'll wait for any response.

Thank you in advance.

14 Replies
I suggest you use built in formulas instead of user defined function. I have written a long formula that achieves converting numeric to words. Will it work for you?

Yes, that will be great Sir. I will happy to try it. How will I get that formula?

 

Thanks in advance Sir Jamil.

Solution

Hi Christoffer,

 

This one was a hell of a formula.

 

In B2 formula below

 

=IF(A2<=0,"Referred Cell Must be Empty",IF(A2>10^12-0.01,"Exceeds Maximum which is 999999999999.99",TRIM(PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),3,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(A2>=10^9," billion ",""),CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),6,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),8,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),12,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(A2,1)>1," "," ")&IF(AND(A2>=1,A2<2)," ",""))&" and "&IF(ISERROR(FIND(".",A2)),"Only",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),3,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(A2>=10^9," billion ",""),CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),6,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),8,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),12,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(TEXT(MOD(A2,1)*1000,"000"),1)>1," Fils Only"," ")&IF(AND(TEXT(MOD(A2,1)*1000,"000")>=1,TEXT(MOD(A2,1)*1000,"000")<2),"Fil Only",""))))))

 

 

AND in C2 

=IF(A2<1,SUBSTITUTE(B2,"and "," "),IF(ISERROR(FIND(".",A2)),SUBSTITUTE(B2," and "," "),B2))

 

Please see attached sample file.

Good day Mr. Mohammed,

 

Thank you very much for a hell of formula. I was able to check the formula and adjust some as per my concern and it worked!! Though it's really a hell long formula, it really gives me the exact output that I want! Very very much appreciated! Worth the wait.

 

Again, THANK YOU so MUCH Sir!

 

Chris

You are most welcome!

Thanks for your kind feedback.

In a posted conversation Jamil created this amazing formula to convert numbers their equivalent word. It work perfectly, however I just want to alter it slightly so it doesn't include and only at the end

 

for example when I use the number 358 it converts the number to Three Hundred Fifty-Eight and Only.

 

i just want it to read Three Hundred Fifty-Eight.

 

=IF(A2<=0,"Referred Cell Must be Empty",IF(A2>10^12-0.01,"Exceeds Maximum which is 999999999999.99",TRIM(PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),3,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(A2>=10^9," billion ",""),CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),6,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),8,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(INT(A2),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(A2),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(A2),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(A2),REPT(0,12)),12,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(A2,1)>1," "," ")&IF(AND(A2>=1,A2<2)," ",""))&" and "&IF(ISERROR(FIND(".",A2)),"Only",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),3,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(A2>=10^9," billion ",""),CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),6,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),8,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),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(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(TEXT(MOD(A2,1)*1000,"000"),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"))))))

Would it be possible to modify this formula so the and only is eliminated?

 

358 converts to Three Hundred Fifty-Eight and Only

 

I will only be working with whole numbers no decimals.

 

Thank you

 

Jennifer

Hi Jennifer,

Yes, it is possible. Right now I am away from my desk, I will be home in couple of hours and I will write the modified formula here.

THANK YOU!!!!!!

Jamil

 

sorry to bother you but any luck updating this formula?

Hi Jennifer,

 

here is the formula. also embedded it in the attached workbook.

 

=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," "," ")&IF(AND(A1>=1,A1<2),"","")))))

I just tried this formula and it works great, thanks.@Jamil Mohammad 

@Louis_Arsenault 

 

You are welcome Louis.  

 

Thanks for feedback.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies