# Lesson#19: How to convert digit into word in excel

In this lesson we will learn a method to convert digit into word. I will use functions like CONCATENATE, VLOOKUP, SUM, IF, MOD, which were discussed in my previous posts.

1st Step I have made a list of relevant word phrase from 0 to 19 and 20, 30, 40, 50, 60, 70, 80, 90. I have intentionally kept the zero blank because we don’t spell 0 as “Zero” when converting into word, it is kept silent.
2nd Step For example I have taken the number 123456789 and I am making a chart. In first column I have put 1 to 9. In second column I have added the formula at cell B5 =MOD(\$B\$4, 10^A5) beside 1 which will show the remainder after diving the number by 10^1.

3rd Step At next cell B6 =MOD(\$B\$4, 10^A6)-\$B\$5 beside 2 which will show the result of subtraction between remainder after diving the number by 10^2 and B5.

4th Step At next cell B7 =MOD(\$B\$4, 10^A7)-SUM(\$B\$5:\$B6) beside 3 which will show the result of subtraction between remainder after diving the number by 10^3 and sum of previous cell to B5.

5th Step I have dragged the formula up to 9th cell.

6th Step At the cell D6 I am putting the formula =MOD(\$B\$4, 10^A6) or =MOD(\$B\$4, 100)which will show the remainder after dividing the number by 10^2 or 100.

7th Step Now I will input the logic when the D6 is less than 20 it will lookup the phrase for 0 to 19 and when it will be equal to 20 or larger then it will combine the lookup value for B6 and B5. This is the formula =IF(\$D\$6<20, VLOOKUP(\$D\$6, \$J\$2:\$K\$21, 2,FALSE), CONCATENATE(VLOOKUP(\$B\$6, \$L\$2:\$M\$10, 2,FALSE), ” “, VLOOKUP(\$B\$5, \$J\$2:\$K\$11, 2,FALSE)))

8th Step Next step will be for Hundred. At D7 I will put the value of =\$B\$7/100.

9th Step For spelling it I will put the formula =IF(\$D\$7=0, “”, CONCATENATE(VLOOKUP(\$D\$7, \$J\$2:\$K\$11, 2,FALSE), ” Hundred”))

10th Step For spelling the Thousand portion I have to extract the two digit number by using =(MOD(\$B\$4, 100000)-SUM(\$B\$5:\$B\$7))/1000. At E8  I have put the formula =MOD(\$D\$9, 10)

11th Step At E9 I have put the formula =D9-E8.

12th Step Now the logic is if the value of D9 is less than 20 then it will lookup the phrase for 0 to 19 chart and add “Thousand” as suffix, else it will concatenate the phrase for E9 and E8 then will add “Thousand” as suffix. The formula is =IF(\$D\$9=0, “”,IF(\$D\$9<20, CONCATENATE(VLOOKUP(\$D\$9, \$J\$2:\$K\$21, 2,FALSE), ” Thousand”), CONCATENATE(VLOOKUP(\$E\$9, \$L\$2:\$M\$10, 2,FALSE), ” “, VLOOKUP(\$E\$8, \$J\$2:\$K\$11, 2,FALSE), ” Thousand”))). When D9 will be zero then it will be silent.

13th Step Like the previous steps for spelling Thousand I will put formula for Lakhs. For spelling the Lakh portion I have to extract the two digit number by using =(MOD(\$B\$4, 10000000)-SUM(\$B\$5:\$B\$9))/100000.

14th Step Now the logic is if the value of D11 is less than 20 then it will lookup the phrase for 0 to 19 chart and add “Lakh” as suffix, else it will concatenate the phrase for E11 and E10 then will add “Lakh” as suffix. The formula is =IF(\$D\$11=0, “”,IF(\$D\$11<20, CONCATENATE(VLOOKUP(\$D\$11, \$J\$2:\$K\$21, 2,FALSE), ” Lakh”), CONCATENATE(VLOOKUP(\$E\$11, \$L\$2:\$M\$10, 2,FALSE), ” “, VLOOKUP(\$E\$10, \$J\$2:\$K\$11, 2,FALSE), ” Lakh”))). When D11 will be zero then it will be silent.

15th Step Like the previous steps for spelling Lakh I will put formula for Crore. For spelling the Crore portion I have to extract the two digit number by using =(MOD(\$B\$4, 1000000000)-SUM(\$B\$5:\$B\$11))/10000000.
16th Step Now the logic is if the value of D13 is less than 20 then it will lookup the phrase for 0 to 19 chart and add “Crore” as suffix, else it will concatenate the phrase for E13 and E12 then will add “Crore” as suffix. The formula is =IF(\$D\$13=0, “”,IF(\$D\$13<20, CONCATENATE(VLOOKUP(\$D\$13, \$J\$2:\$K\$21, 2,FALSE), ” Crore”), CONCATENATE(VLOOKUP(\$E\$13, \$L\$2:\$M\$10, 2,FALSE), ” “, VLOOKUP(\$E\$12, \$J\$2:\$K\$11, 2,FALSE), ” Crore”))). When D13 will be zero then it will be silent.
17th Step For spelling it completely I will use CONCETANATE function like I have serehown in picture. The formula will be =CONCATENATE(F13, ” “, F11, ” “, F9, ” “, F7, ” “, F6).
Now the result is here in this picture. Here I have given download link of the file for my readers where another file is available which converts currency to word. 1. express vpn keys 2018 says:
{"ft_lang_label":"__label__en","ft_lang_prob":0.85542166,"math_prob":0.99022204,"size":2988,"snap":"2019-13-2019-22","text_gpt3_token_len":1033,"char_repetition_ratio":0.14242627,"word_repetition_ratio":0.20517929,"special_character_ratio":0.35910308,"punctuation_ratio":0.14520548,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.99800134,"pos_list":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40],"im_url_duplicate_count":[null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-03-20T03:20:53Z\",\"WARC-Record-ID\":\"<urn:uuid:df4a3826-73bb-4da2-bc87-acc1a73252ff>\",\"Content-Length\":\"66736\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:88d3464c-8726-44c7-93b5-d6d38baf19dc>\",\"WARC-Concurrent-To\":\"<urn:uuid:c9574243-1066-48bf-8139-8551803a5897>\",\"WARC-IP-Address\":\"207.174.215.159\",\"WARC-Target-URI\":\"https://excelabcd.co.in/2017/12/how-to-convert-digit-into-word-in-excel\",\"WARC-Payload-Digest\":\"sha1:SE4FCBYG6UF7EOELG7EQ6ZSLATTD565E\",\"WARC-Block-Digest\":\"sha1:75DB7HNIX274LWUIGGYM6HKL4JL2PN6G\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-13/CC-MAIN-2019-13_segments_1552912202199.51_warc_CC-MAIN-20190320024206-20190320050206-00548.warc.gz\"}"}