Skip to main content

How to Convert Numbers to Words in Excel


How to Convert Numbers to Words in Excel


format Cell _(#,##0.00_);[Red](#,##0.00)


= CHOOSE(LEFT(TEXT(B3,"000000000000.00"))+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--LEFT(TEXT(B3,"000000000000.00"))=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),2,1)=0,--MID(TEXT(B3,"000000000000.00"),3,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),3,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),3,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&IF((--LEFT(TEXT(B3,"000000000000.00"))+MID(TEXT(B3,"000000000000.00"),2,1)+MID(TEXT(B3,"000000000000.00"),3,1))=0, ,IF(AND((--MID(TEXT(B3,"000000000000.00"),4,1)+MID(TEXT(B3,"000000000000.00"),5,1)+MID(TEXT(B3,"000000000000.00"),6,1)+MID(TEXT(B3,"000000000000.00"),7,1))=0,(--MID(TEXT(B3,"000000000000.00"),8,1)+RIGHT(TEXT(B3,"000000000000.00")))>0),"Billion and ","Billion "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),4,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--MID(TEXT(B3,"000000000000.00"),4,1)=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),5,1)=0,--MID(TEXT(B3,"000000000000.00"),6,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),5,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),6,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),6,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&IF((--MID(TEXT(B3,"000000000000.00"),4,1)+MID(TEXT(B3,"000000000000.00"),5,1)+MID(TEXT(B3,"000000000000.00"),6,1))=0, ,IF(OR((--MID(TEXT(B3,"000000000000.00"),7,1)+MID(TEXT(B3,"000000000000.00"),8,1)+MID(TEXT(B3,"000000000000.00"),9,1))=0,--MID(TEXT(B3,"000000000000.00"),7,1)>0),"Million ","Million and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),7,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--MID(TEXT(B3,"000000000000.00"),7,1)=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),8,1)=0,--MID(TEXT(B3,"000000000000.00"),9,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),9,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),9,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&IF((--MID(TEXT(B3,"000000000000.00"),7,1)+MID(TEXT(B3,"000000000000.00"),8,1)+MID(TEXT(B3,"000000000000.00"),9,1))=0, ,IF(OR((--MID(TEXT(B3,"000000000000.00"),10,1)+MID(TEXT(B3,"000000000000.00"),11,1)+MID(TEXT(B3,"000000000000.00"),12,1))=0,--MID(TEXT(B3,"000000000000.00"),10,1)<>0),"Thousand ","Thousand and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),10,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--MID(TEXT(B3,"000000000000.00"),10,1)=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),11,1)=0,--MID(TEXT(B3,"000000000000.00"),12,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),11,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),11,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),12,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),12,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&"Doller and Cent "&CHOOSE(MID(TEXT(B3,"000000000000.00"),14,1)+2,,"zero ","One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&CHOOSE(MID(TEXT(B3,"000000000000.00"),15,1)+2,,"zero","One","Two","Three","Four","Five","Six","Seven","Eight","Nine")& " USD Only"

Comments

Post a Comment

Popular posts from this blog

āŠŪાāŠĪાāŠœીāŠĻા āŠ›ંāŠĶ - āŠ…āŠŪીāŠšંāŠĶ

  āŠŪાāŠĪાāŠœીāŠĻા āŠ›ંāŠĶ - āŠ…āŠŪીāŠšંāŠĶ    āŠ…ંāŠŽા āŠŪા āŠĪાāŠ°ું āŠĶāŠ°્āŠķāŠĻ āŠĶુāŠ°્āŠēāŠ­, āŠĶāŠ°્āŠķāŠĻāŠĨી āŠĶુઃāŠ– āŠ­ાંāŠ—ે āŠ›ે, āŠ…āŠ°āŠœ āŠ•āŠ°ી āŠŪાāŠĻે āŠķીāŠķ āŠĻāŠŪાāŠĩું, āŠ§āŠĻāŠ­ાāŠ—્āŠŊ āŠŪાāŠ°ું āŠ†āŠœે āŠ›ે...   āŠēāŠ•્āŠ· āŠšોāŠ°્āŠŊાāŠķી āŠŦેāŠ°ા āŠŦāŠ°ીāŠĻે, āŠŪāŠĻāŠļા āŠ…āŠĩāŠĪાāŠ° āŠ§āŠ°ાāŠĩ્āŠŊો āŠ›ે, āŠ—ુāŠēાāŠŪ āŠĪāŠŪાāŠ°ો āŠ†āŠĩ્āŠŊો āŠŪુāŠļાāŠŦāŠ°, āŠŪાāŠŊાāŠŪાં āŠēāŠŠāŠŸાāŠŊો āŠ›ે...   āŠ•ાāŠŪ, āŠ•્āŠ°ોāŠ§, āŠŪોāŠđ, āŠŪāŠĪ્āŠļāŠ°, āŠŪાāŠŊા āŠĶુāŠ°્āŠŪāŠĪિ āŠŠāŠ° āŠ§ાāŠŊો āŠ›ે, āŠēોāŠ­ āŠēāŠđેāŠ° āŠāŠ• āŠĻāŠĶીāŠŊા āŠĩāŠđે āŠ›ે, āŠ‰āŠļāŠŪેં āŠœીāŠĩ āŠĶુāŠ­ાāŠŊો āŠ›ે...   āŠĪુāŠŪ āŠŽીāŠĻા āŠŠાāŠ° āŠ‰āŠĪાāŠ°ે āŠ•ોāŠĢ āŠŪા, āŠ­āŠ•્āŠĪāŠĻે āŠ•ે āŠķિāŠ° āŠ—ાāŠœે āŠ›ે, āŠ…āŠ°āŠœ āŠ•āŠ°ીāŠĻે āŠŪાāŠĻે āŠķીāŠķ āŠĻāŠŪાāŠĩું, āŠ§āŠĻāŠ­ાāŠ—્āŠŊ āŠŪાāŠ°ું āŠ†āŠœે āŠ›ે...   āŠ•ોāŠˆ āŠĩāŠ–āŠĪ āŠœીāŠĩ āŠœાāŠŊે āŠ§āŠ°āŠŪ āŠŠāŠ°, āŠŪાāŠŊા āŠŠાāŠ›ી āŠēāŠŠāŠŸાāŠĩે āŠ›ે, āŠ†āŠ•ીāŠĻ āŠ…āŠŪાāŠ°ું āŠ°āŠđેāŠĪું āŠĻāŠĨી, āŠŪાāŠ°ું āŠŠાāŠŠ āŠŪāŠĻે āŠ…āŠĨāŠĄાāŠĩે āŠ›ે...   āŠđāŠĩે āŠ‰āŠŠાāŠŊ āŠķું āŠ•āŠ°ું āŠŪાāŠĪાāŠœી, āŠđāŠŪāŠ•ું āŠ•ોāŠˆ āŠŽāŠĪાāŠĩે āŠ›ે, āŠšાāŠ•āŠ° āŠŽેāŠ ો āŠšિāŠĪ્āŠĪāŠŪાં āŠĪāŠŪાāŠ°ો, āŠĶિāŠēāŠŪાં āŠŽāŠđુ āŠ—āŠ­āŠ°ાāŠĩે āŠ›ે...   āŠŪાāŠ°ી āŠđāŠ•ીāŠ•āŠĪ āŠĪું āŠļāŠđુ āŠœાāŠĢે, āŠ˜āŠŸāŠ˜āŠŸāŠŪાં āŠĪું āŠŽિāŠ°ાāŠœે āŠ›ે, āŠ…āŠ°āŠœ āŠ•āŠ°ી āŠŪાāŠĻે āŠķીāŠķ āŠĻāŠŪાāŠĩું, āŠ§āŠĻāŠ­ાāŠ—્āŠŊ āŠŪાāŠ°ું āŠ†āŠœે āŠ›ે...   āŠŪાāŠĻ āŠĻિāŠ°ંāŠœāŠĻ āŠĪું āŠĶુઃāŠ–āŠ­ંāŠœāŠĻ, āŠĻિāŠ°āŠ§āŠĻāŠĻે āŠ§āŠĻ āŠ†āŠŠે āŠ›ે, āŠĩાંāŠિāŠŊા āŠđોāŠŊ āŠĪેāŠĻું āŠŪેāŠĢું āŠŸાāŠģી, āŠĪેāŠĻે āŠĪું āŠŦāŠ°āŠœંāŠĶ āŠ†āŠŠે āŠ›ે...   āŠ­āŠ•્āŠĪ āŠ•āŠ°ે āŠŪા āŠ­āŠ•્āŠĪિ āŠĪāŠŪાāŠ°ી, āŠĪેāŠĻે āŠĪું āŠĶāŠ°્āŠķāŠĻ āŠ†āŠŠે āŠ›ે, āŠœāŠĻ્āŠŪોāŠœāŠĻāŠŪāŠĻાં āŠŠાāŠŠ āŠĻિāŠĩાāŠ°āŠĢ, āŠāŠ• āŠŠāŠēāŠ•āŠŪાં āŠ•ાāŠŠે āŠ›ે...   āŠŽāŠđુāŠšāŠ°-
Post a Comment
Read more

SBI ATM Card Application Form - State Bank of India

1 comment
Read more

āŠ†āŠાāŠĶ āŠ­ાāŠ°āŠĪ āŠĩāŠĄાāŠŠ્āŠ°āŠ§ાāŠĻ āŠ…āŠĻે āŠ…ંāŠ—્āŠ°ેāŠœી āŠķાāŠļāŠĻ āŠ…āŠĻે āŠķાāŠļāŠĻāŠĻો āŠļāŠŪāŠŊāŠ—ાāŠģો

 ðŸ‘ŒāŠŪાāŠđિāŠĪી āŠāŠ•āŠ ી āŠ•āŠ°āŠĻાāŠ° āŠŪિāŠĪ્āŠ°āŠĻે āŠ…āŠ­િāŠĻંāŠĶāŠĻ, āŠāŠ•āŠĩાāŠ° āŠĩાંāŠšો āŠ…āŠĻે āŠĶāŠļ āŠēોāŠ•ોāŠĻે āŠŪોāŠ•āŠēો.    1 = 1193 āŠŪુāŠđāŠŪ્āŠŪāŠĶ āŠ˜ોāŠ°ી    2 = 1206 āŠ•ુāŠĪુāŠŽુāŠĶ્āŠĶીāŠĻ āŠāŠŽāŠ•    3 = 1210 āŠ…āŠ°āŠŪ āŠķાāŠđ    4 = 1211 āŠ‡āŠēāŠĪુāŠĪ્āŠŪિāŠķ    5 = 1236 āŠ°ુāŠ•āŠĻુāŠĶ્āŠĶીāŠĻ āŠŦિāŠ°ોāŠ āŠķાāŠđ    6 = 1236 āŠ°āŠિāŠŊા āŠļુāŠēāŠĪાāŠĻ    7 = 1240 āŠŪુāŠ‡āŠુāŠĶ્āŠĶીāŠĻ āŠŽāŠđāŠ°ાāŠŪ āŠķાāŠđ    8 = 1242 āŠ…āŠē્āŠēાāŠ‰āŠĶ્āŠĶીāŠĻ āŠŪāŠļૂāŠĶ āŠķાāŠđ    9 = 1246 āŠĻāŠļીāŠ°ુāŠĶ્āŠĶીāŠĻ āŠŪેāŠđāŠŪૂāŠĶ    10 = 1266 āŠ—િāŠŊાāŠļુāŠĶીāŠĻ āŠŽાāŠē્āŠŽāŠĻ    11 = 1286 āŠ•ાāŠˆ āŠ–ુāŠķāŠ°ો    12 = 1287 āŠŪુāŠ‡āŠુāŠĶ્āŠĶીāŠĻ āŠ•ૈāŠ•ુāŠŽાāŠĶ    13 = 1290 āŠķાāŠŪુāŠĶ્āŠĶીāŠĻ āŠ•ોāŠŪāŠ°્āŠļ           1290 āŠ—ુāŠēાāŠŪ āŠĩંāŠķāŠĻો āŠ…ંāŠĪ    (āŠ°ાāŠœ્āŠŊāŠ•ાāŠģ - āŠēāŠ—āŠ­āŠ— 97 āŠĩāŠ°્āŠ·)    āŠ–િāŠēāŠœી āŠĩંāŠķ    1 = 1290 āŠœāŠēાāŠēુāŠĶ્āŠĶીāŠĻ āŠŦિāŠ°ોāŠ āŠ–િāŠēāŠœી    2 = 1296 āŠ…āŠēાāŠĶ્āŠĶીāŠĻ āŠ–િāŠēāŠœી    4 = 1316 āŠļāŠđાāŠŽુāŠĶ્āŠĶીāŠĻ āŠ“āŠŪāŠ° āŠķાāŠđ    5 = 1316 āŠ•ુāŠĪુāŠŽુāŠĶ્āŠĶીāŠĻ āŠŪુāŠŽાāŠ°āŠ• āŠķાāŠđ    6 = 1320 āŠĻāŠļીāŠ°ુāŠĶ્āŠĶીāŠĻ āŠ–ુāŠļāŠ°ો āŠķાāŠđ    7 = 1320 āŠ–િāŠēāŠœી āŠĩંāŠķāŠĻો āŠ…ંāŠĪ    (āŠ°ાāŠœ્āŠŊāŠ•ાāŠģ - āŠēāŠ—āŠ­āŠ— 30 āŠĩāŠ°્āŠ·)    āŠĪુāŠ—āŠēāŠ• āŠĩંāŠķ    1 = 1320 āŠ—િāŠŊાāŠļુāŠĶ્āŠĶીāŠĻ āŠĪુāŠ˜āŠēāŠ• I    2 = 1325 āŠŪુāŠđāŠŪ્āŠŪāŠĶ āŠŽિāŠĻ āŠĪુāŠ—āŠēāŠ• II    3 = 1351 āŠŦિāŠ°ોāŠ āŠķાāŠđ āŠĪુāŠ—āŠēāŠ•    4 = 1388 āŠ—િāŠŊાāŠļુāŠĶ્āŠĶીāŠĻ āŠĪુāŠ—āŠēāŠ• II    5 = 1389 āŠ…āŠŽુ āŠŽāŠ•āŠ° āŠķાāŠđ    6 = 1389 āŠŪુāŠđāŠŪ્āŠŪāŠĶ āŠĪુāŠ—āŠēāŠ• III    7 = 1394 āŠļિāŠ•ંāŠĶāŠ° āŠķાāŠđ āŠŠ્āŠ°āŠĨāŠŪ    8 = 1394 āŠĻāŠļીāŠ°ુāŠĶ્āŠĶીāŠĻ āŠķાāŠđ āŠĶુāŠļāŠ°ા    9 = 1395 āŠĻāŠļāŠ°āŠĪ āŠķા
Post a Comment
Read more