Converting numbers to words in Excel is a common task, but Excel doesn’t have the built-in Function for this. However, it can be easily accomplished with the help of Visual Basic for Applications (VBA). In this blog post, we will walk you through the steps of creating a user-defined function that converts a numeric value to words.

We created Simple Excel Formula to Convert Numbers to Words. You can simply Copy and Paste the VBA Function and use it in both Excel Formulas and VBA Procedures. You can Pass any Number to the Function to Spell Number in Words.

## Steps to Convert Numbers to Words

Here are the simple steps for Converting numbers to words in Excel can be done by creating a custom function in Visual Basic for Applications (VBA).

1. Step 1: Open VBA Editor: To start the process, you will first need to open the VBA editor. This can be accomplished by pressing Alt + F11 on your keyboard while in Excel.
2. Step 2: Insert a New Module: Once the VBA editor is open, you should navigate to Insert > Module in the menu. This will create a new module where you can write your code.
3. Step 3: Write the Code/Copy Our NumToWords VBA Code: Within this new module, you will need to input the code that will create your custom function for converting numbers to words. You can either write your own code or use the VBA code provided in the previous section of this post.
4. Step 4: Use the Function: After the code is implemented, you can now use the new function just like any other built-in function in Excel. Simply return to your Excel sheet and in any cell, write =NumToWords(CELL). You should replace CELL with the cell number that contains the numeric value you wish to convert. For example, =NumToWords(A1) will convert the number in cell A1 to words.

With these steps, you can easily convert numbers to words in Excel, enhancing your data analysis and reporting capabilities.

## VBA to Convert Numbers to Words

Here is the easy to use Excel VBA Function to convert number to words. You can copy the below code and paste in your code module.

```Option Explicit

'Main Function to Convert Number to Words
Function NumToWords(ByVal MyNumber)
Dim Units As String
Dim SubUnits As String
Dim TempStr As String
Dim DecimalPlace As Integer
Dim Count As Integer
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "

' Convert MyNumber to string and trim white space
MyNumber = Trim(Str(MyNumber))

' Find position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, ".")

' Convert SubUnits and set MyNumber to Units amount.
If DecimalPlace > 0 Then
SubUnits = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If

Count = 1
Do While MyNumber <> ""
TempStr = GetHundreds(Right(MyNumber, 3))
If TempStr <> "" Then Units = TempStr & Place(Count) & Units
If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = ""
End If
Count = Count + 1
Loop

NumToWords = Application.Trim(Units & SubUnits)
End Function

' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right("000" & MyNumber, 3)
' Convert the hundreds place.
If Mid(MyNumber, 1, 1) <> "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
' Convert the tens and ones place.
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & GetTens(Mid(MyNumber, 2))
Else
Result = Result & GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function

' Converts a number from 10 to 99 into text.
Function GetTens(TensText)
Dim Result As String
Result = "" ' Null out the temporary function value.
If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...
Select Case Val(TensText)
Case 10: Result = "Ten"
Case 11: Result = "Eleven"
Case 12: Result = "Twelve"
Case 13: Result = "Thirteen"
Case 14: Result = "Fourteen"
Case 15: Result = "Fifteen"
Case 16: Result = "Sixteen"
Case 17: Result = "Seventeen"
Case 18: Result = "Eighteen"
Case 19: Result = "Nineteen"
Case Else
End Select
Else ' If value between 20-99...
Select Case Val(Left(TensText, 1))
Case 2: Result = "Twenty "
Case 3: Result = "Thirty "
Case 4: Result = "Forty "
Case 5: Result = "Fifty "
Case 6: Result = "Sixty "
Case 7: Result = "Seventy "
Case 8: Result = "Eighty "
Case 9: Result = "Ninety "
Case Else
End Select
Result = Result & GetDigit(Right(TensText, 1)) ' Retrieve ones place.
End If
GetTens = Result
End Function

' Converts a number from 1 to 9 into text.
Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = "One"
Case 2: GetDigit = "Two"
Case 3: GetDigit = "Three"
Case 4: GetDigit = "Four"
Case 5: GetDigit = "Five"
Case 6: GetDigit = "Six"
Case 7: GetDigit = "Seven"
Case 8: GetDigit = "Eight"
Case 9: GetDigit = "Nine"
Case Else: GetDigit = ""
End Select
End Function
```

Now that you have defined the function, you can use it just like any other Excel function. You can use it as Excel formula in a Cell or you can assign to a variable in VBA.

## Excel Formula to Convert Numbers to Words?

The `NumToWords` function, created in Excel VBA, converts numbers into their word equivalent. This is especially handy for writing checks, generating invoices, or creating certain reports. The example table provided uses this function. It has three columns: ‘Number’, ‘Formula’, and ‘Result’. ‘Number’ holds the numerical values. ‘Formula’ applies the `NumToWords` function to the numbers in Column A. ‘Result’ shows the output of the function – the verbal representation of the numbers.

To use this function, remember to first implement `NumToWords` in your Excel VBA as outlined in the prior steps.

`=NumToWords(A1)`

Number(A) Formula(B) Result(C)
1 `=NumToWords(A2)` One
23 `=NumToWords(A3)` Twenty Three
456 `=NumToWords(A4)` Four Hundred Fifty Six
7890 `=NumToWords(A5)` Seven Thousand Eight Hundred Ninety
12345 `=NumToWords(A6)` Twelve Thousand Three Hundred Forty Five

Your number will be converted to words in the cell where you wrote the formula!

### Numbers to Words – VBA Use Cases

The `NumToWords` function in Excel VBA converts numeric values to words. To use it, you first open the VBA editor (`Alt + F11`), create a new module, and input the function code. Once it’s implemented, you can use it within your VBA scripts.

`=strNumberToWord=NumToWords(A1)`

For example:

1. Assign it to a variable:
• Dim result As String
• `result = NumToWords(123)`
2. Show the result in a message
• `MsgBox NumToWords(123)`
3. Enter the result in a cell,
• `Range("A1").Value = NumToWords(123)`
• which will enter the converted word form of the number into cell A1. This function extends Excel’s capabilities and offers more flexibility.

Remember, user-defined functions in Excel VBA are powerful and flexible tools that allow you to create new functionality, such as converting numbers to words. However, they are a bit more complex and require knowledge of VBA to create and debug.

Here is the Example file with Excel formula to Convert Number to Words. You can see the Example of Function using in both Excel Formula and VBA.

Convert Numbers to Words in Excel

## Excel Formula to Convert Numbers to Words Using LAMBDA Function

Update: Now You Can Use the Newly Introduced LAMBDA Function!

In addition to the VBA code we’ve previously discussed for converting numbers to words in Excel, we now introduce a powerful and efficient method using the new LAMBDA function. This method simplifies the process, eliminating the need for VBA and allowing you to achieve the same results directly within your worksheet. The LAMBDA function, a recent addition to Excel, enables you to define custom functions using Excel formulas, making your workbook more dynamic and versatile.

### The LAMBDA Formula

Below is the LAMBDA function that converts numbers to words for values ranging from 0 up to 10 million. This formula is comprehensive and handles various numeric ranges including units, tens, hundreds, thousands, and millions.

```=LAMBDA(num,
LET(
singleDigits, {"Zero", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine"},
teens, {"Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen"},
tens, {"", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety"},

units, MOD(num, 10),
tensPlace, MOD(INT(num / 10), 10),
hundredsPlace, MOD(INT(num / 100), 10),
thousandsPlace, MOD(INT(num / 1000), 1000),
millionsPlace, INT(num / 1000000),

words,
IF(
num < 10, INDEX(singleDigits, num + 1),
IF(
num < 20, INDEX(teens, num - 9),
IF(
num < 100, INDEX(tens, tensPlace + 1) & IF(units <> 0, "-" & INDEX(singleDigits, units + 1), ""),
IF(
num < 1000, INDEX(singleDigits, hundredsPlace + 1) & " Hundred" & IF(MOD(num, 100) <> 0, " " & NUM2WORDS(MOD(num, 100)), ""),
IF(
num < 1000000, NUM2WORDS(INT(num / 1000)) & " Thousand" & IF(MOD(num, 1000) <> 0, " " & NUM2WORDS(MOD(num, 1000)), ""),
IF(
num < 10000000, NUM2WORDS(millionsPlace) & " Million" & IF(MOD(num, 1000000) <> 0, " " & NUM2WORDS(MOD(num, 1000000)), ""),
"Number out of range"
)
)
)
)
)
),
words
)
)
```

### Steps to Define the LAMBDA Function

• Open Excel.
• Go to the “Formulas” tab.
• Click on “Name Manager”.
• Click on “New” to create a new named formula.
• In the “Name” field, enter NUM2WORDS.
• In the “Refers to” field, paste the above LAMBDA function.

### Using the NUM2WORDS Function

Once you’ve defined the NUM2WORDS named formula, you can use it in any cell within your worksheet. Simply enter the formula =NUM2WORDS(cell_reference) where cell_reference is the cell containing the number you want to convert. For example:

` =NUM2WORDS(A1)`

This function will convert the numeric value in cell A1 to its corresponding word form, providing a seamless and automated way to enhance your Excel projects.

• If you type the formula =NUM2WORDS(35500), it will give you: Thirty-Five Thousand Five Hundred
• If Range A1=5050000, it will output: Five Million Fifty Thousand.
• You can customize to suite your needs based on your data

Note: Maximum Range

This LAMBDA function supports converting numbers up to 10 million. If you need to handle larger numbers, you will need to extend the logic further to accommodate those values.

### Conclusion

Note: Keep in mind that this VBA function will only work with whole numbers between 0 and 999999999999999. If you need to work with very large numbers or decimals, the code would need to be modified.

We hope you found our post on converting numbers to words in Excel valuable and practical. Your thoughts and feedback are extremely important to us!

If you’ve tried this technique or have any questions about it, please feel free to share your experiences in the comments below. We’d love to hear how this function has worked for you or if there are any other methods you’ve found useful.

Your input helps us make our content better and more relevant to your needs. Additionally, if you’ve encountered any issues or difficulties along the way, share those as well so we can improve our instructions.

Thank you again for reading our blog. Your engagement helps us create more useful content for you and other readers.

1. saleem March 29, 2024 at 6:54 am - Reply

your VBA code is working ggreat, great Job
Thank you for all you support!

2. Isaac April 14, 2024 at 6:20 am - Reply

will it work with currency?

• PNRao April 21, 2024 at 7:27 am - Reply

Yes! You can format the data using Excel Number Formatting (Currency).

3. Sudantha June 25, 2024 at 6:52 am - Reply

When I type that formula I got the answer as “#NAME?

• PNRao June 27, 2024 at 10:16 am - Reply

Please make sure to insert a module and paste the provided VBA code.

4. DES July 8, 2024 at 6:57 am - Reply

How to implement for decimals?

5. deepak siani July 13, 2024 at 8:13 am - Reply

can give a formula of convert number to hindi word