SResultWords = sResultWords & ' and ' & sResultWordsDecimal SResultWords = sResultWords & ' ' & CurrencyUnit If sText '' Then sResultWords = sText & sPlace0(iPlaceIdx) & sResultWords If sText '' Then sResultWords = sText & sPlace1(iPlaceIdx) & sResultWords SResultWordsDecimal = sResultWordsDecimal & ' ' & CurrencylUnitDecimal SDecimal = VBA.Mid(sAmt, iDecimalIdx + 1, 2) SAmt = VBA.Replace(sAmt, ' ', '',, , vbTextCompare) SAmt = VBA.Replace(sAmt, ',', '',, , vbTextCompare) 'Indian Number Format String - Rupees & Paise 'US Number Format String - Dollars & Cents Option Explicitįunction Num2Words(iAmtNumber As Double, iCurrencyFormat As Integer) As Stringĭim sAmt As String, sDecimal As String, sText As Stringĭim sResultWords As String, sResultWordsDecimal As Stringĭim CurrencyUnit As String, CurrencylUnitDecimal As Stringĭim bFirstEntry As Boolean, dCurrencyFormatSplit As Double In case if you are looking for Indian Number formatting in Lakhs, Crores – it is still under development. It can create words for number formats in thousand, Million, Billion & up to trillion. This code is just a modified version from this link. Spell Numbers – Amount to Words – Rupee & Dollar So, for the same convention, the modern automated billing, invoice apps also follow this method. It was older convention to write down using pen in numbers & words to double confirm that no one changes the numbers after a transaction is confirmed. In many accounting, billing & invoicing Excel app, we need to convert the Amounts in Numbers To Words. Get Amount converted from Number to Words both in Millions & Crores format. Amount in Numbers To Words – Both Million & Crores

Amount in words in excel