hello permission to ask

jhon

hello permission to ask

why the formula for the number is spelled out like this it can't be on the smartsheet

=IF(A1=0;"zero";IF(A1<0;"minus ";"")& SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE)) (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( IF(--MID(TEXT(000S(3)0001)");"); 0;"";MID(TEXT(ABS(A1);"000000000000000");1;1)&" hundred "&MID(TEXT(ABS(A1);"000000000000000");2;1)&"twenty "&MID (TEXT(ABS(A1);"000000000000000");3;1)&"trillion ")& IF(--MID(TEXT(ABS(A1);"000000000000000");4;3)=0;"" ;MID(TEXT(ABS(A1);"000000000000000");4;1)&" hundred "&MID(TEXT(ABS(A1);"000000000000000");5;1)&"twenty"&MID(TEXT(ABS (A1);"000000000000000");6;1)&" billion ")& IF(--MID(TEXT(ABS(A1);"000000000000000");7;3)=0;"";MID(TEXT (ABS(A1);"000000000000000");7;1)&" hundred "&MID(TEXT(ABS(A1);"000000000000000");8;1)&"twenty"&MID(TEXT(ABS(A1); "000000000000000");9;1)&" million ")& IF(--MID(TEXT(ABS(A1);"000000000000000");10;3)=0;"";IF(--MID(T EXT(ABS(A1);"000000000000000");10;3)=1;"*";MID(TEXT(ABS(A1);"000000000000000");10;1)&" hundred "&MID(TEXT(ABS (A1);"000000000000000");11;1)&"twenty ")&MID(TEXT(ABS(A1);"000000000000000");12;1)&" thousand ")& IF(--MID(TEXT( ABS(A1);"000000000000000");13;3)=0;"";MID(TEXT(ABS(A1);"000000000000000");13;1)&" hundred "&MID(TEXT(ABS(A1) ;"000000000000000");14;1)&"twenty"&MID(TEXT(ABS(A1);"000000000000000");15;1));1;"one");2;"two");3; "three");4;"four");5;"five");6;"six");7;"seven");8;"eight");9;"nine");"0 hundred ";"");"0ty";"");"onety 0";"ten");"onety one";"eleven");"onety two";"twelve");"one thirty-three";"thirteen");"onety-four";"fourteen");"onety-five";"fifteen");"onety-six";"sixteen");"onety-seven";"seventeen ");"one hundred";"eighteen");"onety-nine";"nineteen");"one hundred";"one hundred");"*one thousand";"one thousand");0;"" ));" ";" "))

or the formula is wrong, if there is a formula for the calculated amount, please help me, thank you

Paul Newcome

What exactly are you trying to accomplish with your formula?

jhon

I want to make an example like this

jhon

let's say $100 becomes a hundred dollars

Andrée Starå

Hi @jhon

I hope you're well and safe!

This post might help.

https://community.smartsheet.com/discussion/25186/help-on-formula-format-numbers-and-shorten-to-k-thousand-m-million-b-billion

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!