4 ms·
One of my about 10 year old accomplishment is creating a single sheet to convert numbers to words (123 to One Hundred Twenty Three) in excel without using VBA o
by davchana 4y ago
One of my about 10 year old accomplishment is creating a single sheet to convert numbers to words (123 to One Hundred Twenty Three) in excel without using VBA or Macro. Our IT didn't allow that pesky dialogue saying Enable Macro or something.
Its a two part sheet. One table sis a simple two column lookup where 1 2,3,...9,11,12....19,30,40,....90,100,1000,100000... etc are in front of One, Two, Three etc. All the vocabulary required to write a number.
Second table is a 9 row table, each row working on a digit of maximum number of 9 digits. First row works on 1st number of 9 long number. If its a smaller number like 12657, the first 4 rows return blank string. 5th row works on 1 of 12657. Kind of like loop. Every third from left gets Hundred, Thousand, Million word etc. Every 2-3 etc gets translated if its 11 to 19 or 20+1.
Since 10 years it has worked nicely, and everytime I use it to convert numbers to words for cheque printing, I feel good.
I wrote a bit about it here https://davinder.net/excel-numbers-to-words-no-VBA-part-01/ https://davinder.net/excel-numbers-to-words-no-VBA-part-01/