How To Convert Number To Words in Excel

HOME PRODUCTS DOWNLOADS SUPPORT BLOG ABOUT US PURCHASE
Two best ways to convert numbers to words in Excel

Aug by Alexander Frolov | updated on November 15, 2016 225 Comments
29
In this article I will show you two quick and free ways to convert currency numbers into English words in Custom Search
Excel 2010, 2013 and other versions.
Microsoft Excel is a great program to calculate this and that. It was initially developed to process
large data arrays. However, it also lets creating accounting records like invoices, evaluation or Excel: featured articles
balance sheets quickly and effectively.
Merge multiple sheets into one
In more or less solid payment documents it is necessary to duplicate numeric values with their
Compare 2 columns in Excel for
word form. It is much harder to falsify typed numbers than those written by hand. Some swindler
matches and differences
can try to make 8000 out of 3000, while it is almost impossible to secretly replace "three" with
"eight". Compare 2 Excel files/sheets for
differences
So what you need is not just convert numbers to words in Excel (е.g. 123.45 to "one hundred and
How to merge Excel files into one
twenty three, forty five"), but spell out dollars and cents (е.g. $29.95 as "twenty nine dollars and
ninety nine cents" ), pounds and pence for GBP, euros and eurocents for EUR, etc. Merge 2 columns in Excel
Merge Excel rows without losing

I have data
enjoyed every bit of it and
time amHowusing
to createitcalendar in Excel
Christian Onyekachi Nwosu
(drop-down and printable)
CONCATENATE in Excel: combine

text strings, cells and columns
How to Vlookup to return

multiple matches in Excel
Even Excel 2013 doesn't have a built-in tool for spelling numbers, not to mention earlier versions. Excel VLOOKUP tutorial for
But that is when Excel is really good. You can always improve its functionality using formulas in all beginners with formula examples
their Excel INDEX / MATCH functions
combinations, VBA macros, or third-party add-ins. instead of VLOOKUP
Below you'll find two ways to convert numbers from figures to words 3 ways to remove spaces
between words / numbers in
SpellNumber VBA macro to convert a numeric value into English words Excel cells
Use an add-in to spell numbers to words Excel COUNTIF examples - not
And, possibly, you may need to convert Words to Numbers in Excel blank, greater than, duplicate or
unique
Note. If you are looking for the number to text conversion, which means you want Excel to Find duplicates in Excel
see your number as text, it's a bit different thing. Usually, you simply need to change the cell
format in Excel (select your range with numbers, press Ctrl+1 on the Number tab, and select Сalculate time in Excel - time
"Text" in the Category field). You can also use the formula =text(). difference, adding / subtracting
times
Please find the details in the article Ways to convert numbers to text in Excel.
Separate names in Excel: split
first and last name into different
columns
SpellNumber VBA macro to convert numbers to words
As I have already mentioned, Microsoft didn't want to add a tool for this task. However, when they Outlook: featured articles
saw how many users needed it, they created and published the special VBA macro on their
Сreate and use e-mail templates
website. The macro does what its name SpellNumber suggests. All other macros I came across are
in Outlook
based on the Microsoft code.
https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

Page 1 of 20
You can find the macro mentioned as "spellnumber formula". However, it is not a formula, but a Merge duplicate contacts in
macro function, or to be more precise Excel User defined function (UDF). Outlook
The spellnumber option is able to write dollars and cents. If you need a different currency, you can How to fix "Cannot start
change "dollar" and "cent" with the name of your one. Microsoft Outlook. Unable to
open Outlook window" error
If you are not a VBA savvy guy, below you will find a copy of the code. If you still don't want or
Outlook BCC - what blind carbon
haven't time to sort this out, please use this solution.
copy is and how to add Bcc
1. Open the workbook where you need to spell the numbers. recipients in Outlook
2. Press Alt+F11 to open the Visual Basic editor window. Remove duplicate emails in
Outlook quickly and safely
3. If you have several books opened, check that the needed workbook is active using the list of
projects in the upper left corner of the editor (one of the workbook elements is highlighted
with blue).
4. In the editor menu go to Insert-> Module.

Excel formulas
Excel functions
Vlookup in Excel
Merge data in Excel SumIf
Excel CountIf Excel Compare
Excel If statement
Excel Charts Pivot Table
Excel conditional formatting

Excel formatting Excel time
5. You should see a window named YourBook - Module1. Select all of the code in the frame below Excel duplicates Excel date
and paste it to this window.
Excel tips
Google Sheets Outlook
Outlook duplicates Outlook BCC
Outlook templates
Sign in
Register
Log in
Option Explicit ?
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "
MyNumber = Trim(Str(MyNumber))
DecimalPlace = InStr(MyNumber, ".")
If DecimalPlace > 0 Then

Page 2 of 20
Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
"00", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
Count = 1
Do While MyNumber <> ""
Temp = GetHundreds(Right(MyNumber, 3))
If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars
If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = ""
End If
Count = Count + 1
Loop
Select Case Dollars
Case ""
Dollars = "No Dollars"
Case "One"
Dollars = "One Dollar"
Case Else
Dollars = Dollars & " Dollars"
End Select
Select Case Cents
Case ""
Cents = " and No Cents"
Case "One"
Cents = " and One Cent"
Case Else
Cents = " and " & Cents & " Cents"
End Select
SpellNumber = Dollars & Cents
End Function
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
Function GetTens(TensText)
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
Function GetDigit(Digit)
Select Case Val(Digit)

Page 3 of 20
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
6. Press Ctrl+S to save the updated workbook.
You will need to resave your workbook. When you try to save the workbook with a macro you'll
get the message "The following features cannot be saved in macro-free workbook"
Click No. When you see a new dialog, chose the Save as option. In the field "Save as type" pick
the option "Excel macro-enabled workbook".
Use SpellNumber macro in your worksheets

Now you can use the function SpellNumber in your Excel documents. Enter =SpellNumber(A2)
into the cell where you need to get the number written in words. Here A2 is the address of the cell
with the number or amount.

Page 4 of 20
Here you can see the result:
Voila!
Quickly copy the SpellNumber function to other cells.

If you need to convert the entire table, not just 1 cell, place your mouse cursor to the lower right
corner of the cell with the formula until it turns into a small black cross:
Left-click and drag it across the column to fill in the formula. Release the button to see the results:
Note. Please keep in mind that if you use SpellNumber with a link to another cell, the written
sum will be updated each time the number in the source cell is changed.
You can also enter the number directly into the function, for example, =SpellNumber(29.95)
(29.95 - without quotation marks and the Dollar sign).
Disadvantages of using macro to spell numbers in Excel

First off, you must know VBA to modify the code according to your needs. It is necessary to paste
the code for each workbook, where you plan to change it. Otherwise, you will need to create a
template file with macros and configure Excel to load this file at each start.
The main disadvantage of using a macro is if you send the workbook to somebody else, this
person will not see the text unless the macro is built into the workbook. And even if it's built-in,
they will get an alert that there are macros in the workbook.

Page 5 of 20
Free ready-to-use add-in to spell numbers into words
For active Excel users who need to quickly spell sums but don't want to learn VBA or other
workarounds, one kind developer created a free add-in - POPUP SPELL NUMBER for Microsoft
Excel
Besides being ready for use, the tool is really flexible in converting numbers. You can choose the
text case of the result (lower case, Title Case, Sentence case, UPPER CASE ), also you can select
how you want to see the fraction:
Spells the fraction in cent/cents, оr penny/pennies, оr penny/pence, or centavo/centavos
Spells decimal point, each zero and the rest of the number as an integer.
Doesn't spell the fraction but writes it as a fraction with denominator of 100, 1000, 1000000
Feel free to explore its possibilities on the product's home page.
The author states that it's tested and works in Excel for Windows 2000, 2002(XP), 2003, 2007, 2010
(32-bit), and 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based
services.
And all is wonderful about POPUP SPELL NUMBER, but...

I hate to say that the add-in doesn't work with 64-bit versions of Excel 2010, 2013, 2007. And it
is a considerable obstacle since these versions are becoming more and more popular. So lucky
you are if you have Excel 32-bit :) Feel free to download the add-in and check it out.
If you are the one with Excel 64-bit like me, drop the author a line and ask him for a special
version.
Reverse conversion - English words into numbers

Frankly, I can't imagine why you may need it. Just in case... :)
It appears that Excel MVP, Jerry Latham, created such Excel User defined function (UDF) as
WordsToDigits. It converts English words back to number.
You can download Jerry's WordsToDigits workbook to see the UDF code. Here you'll also find his
examples of how to use the function.

Page 6 of 20
You can see how the function works on the sheet "Sample Entries", where you will also be able to
enter your own examples. If you plan to employ WordsToDigits in your documents, please be
informed that this function has restrictions. For example, it doesn't recognize fractions entered in
words. You will find all the details on the "Information" sheet.
See also
Merge Excel worksheets by matching data
Combine Excel sheets with the same name into one
20+ smart tools for Excel 2013-2003 to do your daily work
225 Responses to "Two best ways to convert numbers to words

in Excel"
Older Comments
1 Umer says:
August 29, 2016 at 6:16 am
Sir, How can i convert dollar into Rupees and cent Into paisa in SpellNumber. I mean i want to
change numeric value into words in pakistani currency. Kindly guide.
Your early response must be appreciated
Reply
sohaib says:
December 15, 2017 at 5:12 pm
Umer its very simple, after copying the above formula into module press CTRL+H and re-
place the word Dollar with Rupee and Cent with Paisa and then safe the module.
Reply
2 Albert says:
September 2, 2016 at 4:07 pm
Beautiful!!!!
Thank you for posting and making it so easy to implement. Really helped out in a crunch.
Reply
3 Irfan says:
Please send me same excel sheet with formula,
Reply
4 Thangamani says:
This one how do the amount currency change?
Reply
5 Jolyn says:
September 7, 2016 at 8:54 am
Hi,
Can i have a copy of the formula in excel for the converted value, please ?
Reply
6 Ali Mehran Wafai says:


Page 7 of 20
Thank You So Much :)
Reply
7 Salman says:
If you want only integers to be spelled no decimals.. here is the code
Option Explicit
'Main Function
Dim Rupees, Paisas, Temp
Place(2) = " Thousand "
' String representation of amount.
' Position of decimal place 0 if none.
' Convert Paisas and set MyNumber to Rupee amount.
End If
Count = 1
Do While MyNumber ""
If Temp "" Then Rupees = Temp & Place(Count) & Rupees
Else
MyNumber = ""
End If
Count = Count + 1
Loop
Select Case Rupees
Case ""
Rupees = "No Rupees"
Case "One"
Rupees = "One Rupee"
Case Else
Rupees = Rupees & " Rupees"
End Select
SpellNumber = Rupees
End Function
' Converts a number from 100-999 into text

If Mid(MyNumber, 1, 1) "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
Else
End If

Page 8 of 20
End Function
' Converts a number from 10 to 99 into text.

Case Else
End Select
Case Else
End Select
End If
GetTens = Result
End Function

End Select
End Function
"Ctrl+H" and replace "Rupees & Rupee" to your respective currency
Reply
sohaib says:
how can we add the word "Only" in this macro to have this word at the end of the spelled
values?
Reply

Page 9 of 20
Mir Osman ALi says:
January 17, 2018 at 8:28 am
Hi Sohaib
If You Want To Add "Only"

then
You have to use "Spellnumber" with "Concatenate" Formula
Eg:
If the Value in Number in Cell A1 then
Apply Formula Like This
=CONCATENATE(SpellNumber(A1)," Only")
Hope Will Be Useful
Reply
Fabienne says:
March 5, 2018 at 8:37 am
Super helpful. It's also useful if you have a currency in 2 words, like Ugandan Shilling.
You can replace Dollars only with 1 word.
so I replaced Dollars by Ugandan and I added Shillings, in the end, with CONCATENATE
instead of Only.
=CONCATENATE(SpellNumber(A1)," Shillings")
Reply
Kenny Telfer says:

May 4, 2018 at 3:01 pm
Some errors in that code for me, I've fixed and changed to UK Pounds, also added "and"
between the thousand and the hundreds, and a comma.
Option Explicit
'Main Function
Dim Pounds, Pence, Temp
Place(2) = " Thousand, "
' String representation of amount.
' Position of decimal place 0 if none.
' Convert Pence and set MyNumber to Pounds amount.
End If
Count = 1
Do While MyNumber ""
If Temp "" Then Pounds = Temp & Place(Count) & Pounds
Else
MyNumber = ""
End If
Count = Count + 1
Loop
Select Case Pounds
Case ""

Page 10 of 20
Pounds = "No Pounds"
Case "One"
Pounds = "One Pound"
Case Else
Pounds = Pounds & " Pounds"
End Select
SpellNumber = Pounds
End Function
' Converts a number from 100-999 into text

Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred and "
End If
Else
End If
End Function

Case Else
End Select
Case Else
End Select
End If
GetTens = Result
End Function

Page 11 of 20
End Select
End Function
Reply
8 SIKANDAR GHODESHWAR says:

October 4, 2016 at 8:25 am
Sir,
Please send details of excel sheet in permanent add for automatically spellnumber on MS ex-
cel- 2007.
Thanking you
Reply
9 Saiful Islam says:

October 13, 2016 at 12:58 pm
Dear Stephen,
please send me excel sheet for
converting same
Reply
10 vampire says:
I have a lot of city name and code
Example
i type a code 001 At Cell (A1) - spell Number will show (american) at the another sheet
i type a code 002 At Cell (A1) Also - spell Number will show (african) at the another sheet and
so on... I have a lot of city name to make it, please help me
Thanks
Reply
11 sultan says:
Dear Kindly let me know in dirham how to change spellnum in dirham
Reply
12 Bicky kumar says:

November 2, 2016 at 11:49 am
Dear Stephen,
please send me excel sheet for converting same Pls
thanks
Reply
13 ravi says:

Page 12 of 20
please suggest me how to use spellnumber in excel ,i fallowed your steps as u say ,the results
came" #name?,",like that,so plz show me right usage .....
Reply
14 Vishal Patel says:

December 15, 2016 at 5:49 am
i want number to ward in rupees and due to this formula it comes into dollars, than what's
the step for it..............
Reply
15 Raj Kumar says:

Hi Sir,
I am very much need the program that convert the numbers in to English words in excel
2007.(Ex: 11- One One, 20- Two Zero, 21-Two Zero like that)
Please send me the solution for above querry,
it is very much urgent..

thank you very much..
Reply
16 jansen says:
i use the module, but our central bank required us to put a "ONLY" word in the end of the
Check. how can i do this?
Reply
17 Richard Robertson says:

January 18, 2017 at 7:41 pm
Please the code to convert amount to words is excellent, only i think there's something miss-
ing. after the code is pasted in Excel Module, and you key-in 420, the result that comes is:
Four Hundred Twenty Dollars and No Cents. But am expecting Four Hundred and Twenty Dol-
lars and No Cents. This means the an "and" is missing in-between Hundred and twenty.
Thank you and looking forward to hear from you soon.
Reply
18 Puvanah says:
February 3, 2017 at 10:08 am
Can i get modules for spellnumbers in words with cents. I have those modules with currency.
But i'm using multi currencies so i don't want modules with currencies. Please help email me
the modules which i request. Urgent. Please and Thanks.
Regards,
Puvanah
Reply
19 MN says:
How can we split the amount in words into 2 lines in case 1 line is not enough to accommo-
date the amount in words? This is needed when printing on pre-printed cheque leaves.
Can anyone please help on the above?
Reply
20 Aklanka says:
Dear . Alexander Frolov

Page 13 of 20
Thanks for the formula, its works nicely
Reply
21 Abu Sayed kazi says:

Dear Sir please send me the copy of these excel sheet please ,as soon as possible , please
please
Reply
22 KCraton says:
February 23, 2017 at 11:30 pm
Thank you! Copied and pasted the module, saved my file as an .xlm and bada-boom!
Reply
23 sunil kumar yadav says:

March 3, 2017 at 2:17 am
how to delete the rows using check bos in excel.
Reply
24 RAZAK says:
March 12, 2017 at 11:04 am
Working done ,
after save i close this file again open try modify and try change then its showing error
Reply
25 Daniel Kwame Dadzie says:

March 28, 2017 at 7:46 pm
Hi all,
Can someone assist me to write
1020 as one thousand and twenty not one thousand twenty please.
Thank you in advance
Reply
Boss says:
March 31, 2017 at 7:16 am
Just put "and ..." on GetTens' function, dude
Reply
26 Boss says:
March 31, 2017 at 7:14 am
What if I would like to put a special name?

ex. for 100 will be "clint"
Therefore,
100 = Clint
150 = Clint Fifthy
123 = Clint Twenty Three
etc..
NB: Only for "100"
Reply
Natalia Sharashova (Ablebits.com Team) says:

April 13, 2017 at 6:30 am
If you want the word 'Clint' to stand for '100', you will need to modify the code. Try asking
for it on MrExcel forum.

Page 14 of 20
Reply
27 ASIF KHAN says:

April 15, 2017 at 8:46 am
It is very simple to convert dollar into your currency for example if you have a Rupee go to
Module (micro-soft visual basic) enter Ctrl + R just replace dollar and cent with your currency.
Thanks for more details kindly contact on my email. asifashraf930@gmail.com
Reply
28 Beth says:
April 16, 2017 at 2:52 pm
Please send me the excel sheet for converting dollars to words. I tried to paste from an earlier
Spellnumber post using VBA but I get a #Name error.
Thank you.
Reply
Natalia Sharashova (Ablebits.com Team) says:

April 21, 2017 at 6:33 am
The VBA code from the example above works perfectly when we try it. Please, repeat the
steps from the tutorial making sure that you paste the code without losing any lines, and
save your document in the proper way as it is described. If this still doesn't help, try our
add-in. If the error won't disappear, send us your workbook and the link to this article and
your comment to support@ablebits.com.
Reply
29 tanjil says:
April 30, 2017 at 9:32 am
Dear sir, please how to make wordstodigit formula details
Reply
30 Amal says:
May 4, 2017 at 7:39 am
Very useful and clear explanation. 5 Star:D

Thank you for sharing this information with us.
Reply
31 Rohit says:
May 5, 2017 at 10:05 am
Thnks for ur help. Its been a pleasure to have guidance.
Reply
32 JB says:
May 9, 2017 at 8:10 am
I have follwed your instruction & But still the error as #Name is apprearing on the spell num-
ber formula. please help
Reply
33 Srinivas says:
June 3, 2017 at 6:34 pm
Please send me also
Reply
34 Thu Hien Nguyen says:

June 22, 2017 at 5:20 am

Page 15 of 20
Please kindly send me the formula also.
Many thanks.
Reply
35 Tamizi says:
July 11, 2017 at 4:08 am
Please email formula convert to Ringgit Malaysia (RM)
Reply
36 Tamizi says:
July 11, 2017 at 4:09 am
Many thanks to admin
Reply
37 Bikash singh says:

July 26, 2017 at 6:57 am
Please email formula convert number to word
Reply
38 Glenn says:
August 15, 2017 at 7:11 am
I have tried and it was successful. But it was all in dollars.. How about in Qatar Riyals? How
can i do it? Can you feed the module formula?
Reply
39 sunil kumar yadav says:

August 21, 2017 at 2:30 am
I have a file containing multiple sheets the first of which is an index

sheet. The other sheets are hidden. I want to be able to click on a
hyperlink in the index sheet that will send me to the hidden sheet and
open it.
Is this possible ?
Reply
40 David says:
October 23, 2017 at 1:35 pm
Hi, I have an issue where i am trying to spellnumber a figure in a summed cell. I have changed
the currency to GBP and Pence, but the spell number keeps minusing 1 Pence from the writ-
ten number. If i do it on an un-summed cell it works fine.
PLEASE HELP!?
Reply
Irina Pozniakova (Ablebits.com Team) says:

Hello David,
I'm sorry, but we can't reproduce this issue on our side, the function spells numbers from a
summed cell correctly. Could you try to follow the steps from the post again and check if it
works for you?
Reply
David says:
HI Irina
It was only happening between numbers involving 40-70. Very strange as other than that
it works perfectly other than not putting an 'and' in after hundred but we can add that in

Page 16 of 20
no probs.
Quite happy to send the doc if required.
Reply

Hi David,
Thank you for the details. It would be great to have a look at the document, please
send it to support@ablebits.com with a link to this post, it may help us understand
what is causing this strange behaviour.
Reply
41 David says:
Hi Irena
I have emailed you the document as requested. Hope you can help :)
Reply

November 1, 2017 at 12:30 pm
Thank you for the document, David.
The problem is that the formula results are rounded in Excel, while VBA gets a string and
converts only the first 2 characters after the separator. To avoid this issue, please use the
following formula instead:
=spellnumber(ROUND(N24,2))
Reply
42 Bhuraram says:
UpTo 1 Lac Not Convert To In Word Please Help
Reply
43 Ceen says:
Dear David ,
In reference to Irina's chat string the same sheet is required by me .I am unable to poke in
hours in preparing the formulation ready sheet
Much oblighed
Sincerely 'very faithfully
CEEN
Reply
44 Akki says:
November 20, 2017 at 7:41 am
cel- 2016
Awaiting for reply...
Reply
45 Naeem Rajwal says:

Hi Dear, Can you pleases help to fix the decimal up to 3 Digit. Like below:
45.975 -Forty Five Dollar and Nine Hundred seventy Five Cents.
Reply

Page 17 of 20
46 Muhammad Ashfaq says:
January 18, 2018 at 12:07 pm
cel- 2007.
Also please suggest me how to use spellnumber in excel ,i fallowed your steps as u say ,the
results came" #name?,",like that,so plz show me right usage
I am waiting for your reply Thanks Muhammad Ashfaq from Pakistan Karachi.....
Reply
47 Prem says:
Hi, Congrats, It is very helpful. Thank you so much.

How to make change the words starting with Dollars & Cents first.
Eg. Rupees One hundred and Paisa Fifty Only instead of One hundred Rupees and Fifty Paisa
Only.
Br//
Prem
Reply
48 paras says:
January 29, 2018 at 11:33 am
modules after what are the doing
Reply
49 paras says:
January 29, 2018 at 11:33 am
modules after what are the doing 1
Reply
50 harry says:
cel- 2007
Reply
51 Mozammel says:
February 10, 2018 at 12:12 pm
Hello Prem,
Thanks,man. it helped me out.
Regards:
Mozammel
Chittagong, Bangladesh.
Reply
52 Bharath says:
March 7, 2018 at 6:21 am
This is awesome! I know nothing about VBA but it still made it happen with this so Thanks a
ton. however, how do I exclude cents/paisa from the code?i.e. will not need any decimals.
Thanks again.
Reply
53 alicia says:
March 9, 2018 at 8:16 am

Page 18 of 20
I write this formula
=CONCATENATE("US ",spellnumber(cell),"***")
I don't know what's wrong it issue "Name?" Anyone can answer me?
Many Thanks,
Alicia
Reply
54 meharoof says:
March 12, 2018 at 9:37 am
i need to display my currency in riyal instead of dollars ...
Reply
55 Grace says:
April 12, 2018 at 8:27 pm
I was able to use the SpellNumber successfully for all numbers except for numbers that are
only in the thousands with any other numbers (e.g. 54,000 or 30,000). I get two spaces before
the word Dollars. I had a similar problem with numbers that ended in the hundred dollars
and numbers that ended with 20, 30, 40, 50, 60, 70, 80 and 90. To fix the problem, I changed
the GetHundreds = Result to GetHundreds = Trim(Result) and GetTens = Result to GetTens =
Trim(Result). I don't know how to change the code for numbers that are only in the
Thousands.
Reply
56 Diana says:
April 19, 2018 at 9:08 pm
In spanish we do not say "Three hundred" in two words, we say "Trecientos" in one word. Is
there a say to add another clause to list numbers from 100-999
I try to add this but I am getting an error

Case 20: Result = "Ciento"
Case 21: Result = "Doscientos "
Case 22: Result = "Trescientos "
Case 23: Result = "Cuatrocientos "
Case 24: Result = "Quinientos "
Case 25: Result = "Seicientos "
Case 26: Result = "Setecientos "
Case 27: Result = "Ochocientos "
Case 28: Result = "Novecientos "
Reply
57 Mian Muazzam says:

April 21, 2018 at 7:10 am
Sir, If We Want to Remove Cents What Will We Don Please Reply me
Reply
58 Mian Muazzam says:

April 21, 2018 at 7:10 am
Sir, If We Want to Remove Cents What Will We Don Please Reply me
Reply
59 Joseph says:
May 7, 2018 at 3:12 pm
CAN I HAVE A CODE THAT CONVERTS 11 TO ONE ONE OR 22 TO TWO TWO?

Page 19 of 20
Reply
Doug says:
May 7, 2018 at 4:26 pm
The VBA code is in the article above.
Reply
Doug says:
May 8, 2018 at 1:34 pm
Joseph:
The VBA code is in the article above or you need a third party tool.
Reply
60 Chen says:
May 8, 2018 at 4:11 am
Can i get rid of the dollar / dollars word?
example: 6,130.20 = Six Thousand One Hundred Thirty and Twenty Cents
Reply
Older Comments
Post a comment
Name Name
name@example.com E-mail (not published)
Send
Unfortunately, due to the volume of comments received we cannot guarantee that we will be
able to give you a timely response. When posting a question, please be very clear and concise.
We thank you for understanding!
Copyright © 2002 - 2018 Ablebits.com. All rights reserved. Terms of use Contact us
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United
States and/or other countries.

Page 20 of 20

How To Convert Number To Words in Excel

Uploaded by

Copyright:

Available Formats

How To Convert Number To Words in Excel

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

How To Convert Number To Words in Excel

Uploaded by

Copyright:

Available Formats

HOME PRODUCTS DOWNLOADS SUPPORT BLOG ABOUT US PURCHASE

Two best ways to convert numbers to words in Excel

Merge Excel rows without losing

CONCATENATE in Excel: combine

How to Vlookup to return

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

4. In the editor menu go to Insert-> Module.

Excel conditional formatting

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

Function GetHundreds(ByVal MyNumber)

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

6. Press Ctrl+S to save the updated workbook.

Use SpellNumber macro in your worksheets

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

Quickly copy the SpellNumber function to other cells.

Disadvantages of using macro to spell numbers in Excel

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

Spells the fraction in cent/cents, оr penny/pennies, оr penny/pence, or centavo/centavos

Feel free to explore its possibilities on the product's home page.

And all is wonderful about POPUP SPELL NUMBER, but...

Reverse conversion - English words into numbers

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

Combine Excel sheets with the same name into one

20+ smart tools for Excel 2013-2003 to do your daily work

225 Responses to "Two best ways to convert numbers to words

Please send me same excel sheet with formula,

This one how do the amount currency change?

6 Ali Mehran Wafai says:

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

If you want only integers to be spelled no decimals.. here is the code

' Converts a number from 100-999 into text

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

' Converts a number from 10 to 99 into text.

' Converts a number from 1 to 9 into text.

"Ctrl+H" and replace "Rupees & Rupee" to your respective currency

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

If You Want To Add "Only"

If the Value in Number in Cell A1 then

Apply Formula Like This

Hope Will Be Useful

Kenny Telfer says:

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

' Converts a number from 100-999 into text

' Converts a number from 10 to 99 into text.

' Converts a number from 1 to 9 into text.

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

8 SIKANDAR GHODESHWAR says:

9 Saiful Islam says:

I have a lot of city name and code

Dear Kindly let me know in dirham how to change spellnum in dirham

12 Bicky kumar says:

please send me excel sheet for converting same Pls

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/ 21/05/18, 1C08 PM

14 Vishal Patel says:

15 Raj Kumar says:

it is very much urgent..

17 Richard Robertson says:

Can anyone please help on the above?

Dear . Alexander Frolov