Convert a Currency Number to Words in Excel
Convert amount from Number to Words Convert a Currency Number to Words in Excel Step by Step tutorial This VBA code will enable you to convert any amount in an excel cell to words amount with 6 currencies very easily. Steps are below: 1- Open an Excel file and press Alt + F11 2- Click Insert, Module Alt + F11 3- Copy below text and paste it in the module Option Explicit 'https://ilpd-ms.blogspot.com/2020/03/how-to-convert-amount-from-number-to.html Function SpellNumberEDP(ByVal MyNumber, Optional MyCurrency As String = "") Dim Dollars, cents, Temp Dim DecimalPlace, Count ReDim Place( 9 ) As String Place( 2 ) = " Thousand " Place( 3 ) = " Million " Place( 4 ) = " Billion " ...