This formula converts numbers into american currency dollars, but you can adjust it to convert into any currency or unit by just finding and replacing "Dollars" and "Cents". Any number written in B2 will be converted into words. But this man was able to solve this complexity and make this formula work efficiently. The number 12 can be one or two in large numbers or Twelve. It identifies which number comes in which section. This formula Identifies once, tens, hundreds, thousands, millions and billions. Then it uses the CHOOSE function to substitute numbers with the words. This formula determines how long the number is. The formula is too long to explain but I can explain the logic.
You can download the excel file below to check the formula. So, I have mentioned it at the end of the post. The formula is a page long and if I will mention it here now, it will cover the whole post. This user with Id HaroonSid wrote a crazy formula.
The number can have two decimal places too. This formula can convert numbers from range cents to billions. This formula is used to convert a number into American currency. I had never imagined that we could convert numbers into words. But I had never imagined that we can convert numbers to words by just using excel formulas. I had written a number of code lines to achieve this.
In my previous article, I had explained how to convert a number to words in Excel using VBA.
0 kommentar(er)
