In this article I will show you two quick and free ways to convert currency numbers into English words in Excel 2019, 2016, 2013 and other versions. Continue reading
Comments on: Two best ways to convert numbers to words in Excel
by Alexander Frolov, updated on
Comments page 16. Total comments: 530
Beautiful!!!!
Thank you for posting and making it so easy to implement. Really helped out in a crunch.
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
Umer its very simple, after copying the above formula into module press CTRL+H and replace the word Dollar with Rupee and Cent with Paisa and then safe the module.
How can I change Dollars to US Dollars?
could you please send me the copy of these excel sheet please ,as soon as possible , please please
48,683.00
=SpellNumber(...)
Dear Friends,
Requesting you, kindly share the any worked excel sheet to me.
i need the how to change the number to words, becoz i want to create the new manual invoice sheet. any time i want to change the value in number and words also.
kindly do needful
Vinayak There is A Bug in the Module you have pasted request you to pls send me the Revised VBA if possible
Thanks...
Great thanks. This is awesome.
Pls I need the formula on how to convert figures to words in Nigeria currency. Thanks
PLZ GIVE ME SHORT FORMULA CONVERT NUMBER INTO WORD I CAN'T UNDERSTANDING THE FUNCTION OF THIS PROCEDURE
Dear sir/Madam
Kindly request to send excel file - to convert numbers to words in Excel
There IS An Error In Formula
Hi,
is it possible to get this formula for use in french.
Great job
Regards
Thank u very much it's works perfectly nice job.
I convert degree s for student therfore I want to appear only the word with out any other add.
ex: 0 appear zero
no thing appear no thing
41 appear forty one
Please send me a formula for the number to word.
i'm using Microsoft 2010.
hoping for your immediate reply.
Thank you,
Please send me a formula.
i'm using Microsoft 2010.
hoping for your immediate reply.
Thank you,
=CONCATENATE(IF(IF(QUOTIENT($A$3,10000000)0,VLOOKUP(QUOTIENT($A$3,10000000),Sheet1!$A$1:$B$99,2),"")"",CONCATENATE(IF(QUOTIENT($A$3,10000000)0,VLOOKUP(QUOTIENT($A$3,10000000),Sheet1!$A$1:$B$99,2),"")," Cror "),""),IF(IF(QUOTIENT(MOD($A$3,10000000),100000)0,VLOOKUP(QUOTIENT(MOD($A$3,10000000),100000),Sheet1!$A$1:$B$99,2),"")"",CONCATENATE(IF(QUOTIENT(MOD($A$3,10000000),100000)0,VLOOKUP(QUOTIENT(MOD($A$3,10000000),100000),Sheet1!$A$1:$B$99,2),"")," Lac "),""),IF(IF(QUOTIENT(MOD($A$3,100000),1000)0,VLOOKUP(QUOTIENT(MOD($A$3,100000),1000),Sheet1!$A$1:$B$99,2),"")"", CONCATENATE(IF(QUOTIENT(MOD($A$3,100000),1000)0,VLOOKUP(QUOTIENT(MOD($A$3,100000),1000),Sheet1!$A$1:$B$99,2),"")," Thousand "),""),IF(IF(QUOTIENT(MOD(MOD($A$3,100000),1000),100)0,VLOOKUP(QUOTIENT(MOD(MOD($A$3,100000),1000),100),Sheet1!$A$1:$B$99,2),"")"",CONCATENATE(IF(QUOTIENT(MOD(MOD($A$3,100000),1000),100)0,VLOOKUP(QUOTIENT(MOD(MOD($A$3,100000),1000),100),Sheet1!$A$1:$B$99,2),"")," Hundred "),""),IF(MOD(MOD(MOD($A$3,100000),1000),100)0,VLOOKUP(MOD(MOD(MOD($A$3,100000),1000),100),Sheet1!$A$1:$B$99,2)))
Please use following formulas and change cell references according to your sheet and dont forget to add a 1-99 numbers and their words in sheet1 like A1=1,B1=One and up to 99. This works and dont need micros also.
=CONCATENATE(IF(IF(QUOTIENT($A$3,10000000)0,VLOOKUP(QUOTIENT($A$3,10000000),Sheet1!$A$1:$B$99,2),"")"",CONCATENATE(IF(QUOTIENT($A$3,10000000)0,VLOOKUP(QUOTIENT($A$3,10000000),Sheet1!$A$1:$B$99,2),"")," Cror "),""),IF(IF(QUOTIENT(MOD($A$3,10000000),100000)0,VLOOKUP(QUOTIENT(MOD($A$3,10000000),100000),Sheet1!$A$1:$B$99,2),"")"",CONCATENATE(IF(QUOTIENT(MOD($A$3,10000000),100000)0,VLOOKUP(QUOTIENT(MOD($A$3,10000000),100000),Sheet1!$A$1:$B$99,2),"")," Lac "),""),IF(IF(QUOTIENT(MOD($A$3,100000),1000)0,VLOOKUP(QUOTIENT(MOD($A$3,100000),1000),Sheet1!$A$1:$B$99,2),"")"", CONCATENATE(IF(QUOTIENT(MOD($A$3,100000),1000)0,VLOOKUP(QUOTIENT(MOD($A$3,100000),1000),Sheet1!$A$1:$B$99,2),"")," Thousand "),""),IF(IF(QUOTIENT(MOD(MOD($A$3,100000),1000),100)0,VLOOKUP(QUOTIENT(MOD(MOD($A$3,100000),1000),100),Sheet1!$A$1:$B$99,2),"")"",CONCATENATE(IF(QUOTIENT(MOD(MOD($A$3,100000),1000),100)0,VLOOKUP(QUOTIENT(MOD(MOD($A$3,100000),1000),100),Sheet1!$A$1:$B$99,2),"")," Hundred "),""),IF(MOD(MOD(MOD($A$3,100000),1000),100)0,VLOOKUP(MOD(MOD(MOD($A$3,100000),1000),100),Sheet1!$A$1:$B$99,2)))
Hi Ronak,
Follow the steps below to split the numbers you have mentioned and any other number.
1. Highlight the column you want the numbers to be split.
2. On the formula tab select Data and then select Text to columns. Step 1 of 3: Of the two option in the dialogue box select Fixed width and click on Next.
3. Step 2 of 3:In the lower section of the dialogue box, Data preview, section place your cursor where you want the numbers to be split and click on Next.
4. Step 3 of 3: Select "General" in the column data format section and in the Destination option select the cell you want the data to be split.
When you click on Finish you will see the data split in the number of columns depending on the number of digits.
Word of caution - The original data will no longer be available so if you need to see the data in its original form then retain the original column and split the numbers from a copied column next to the original to for verifying purposes.
Regards.
IF ITS POSSIBLE THEN WHAT IS THE FORMULA????
I want to convert 11 into " ONE ONE ".
12 into " ONE TWO " AND SO ON.
It's possible or not????
It works with numbers big as 999.999.999.999.999,19
For example
137.895,19 results as
One Hundred Thirty Seven Thousand Eight Hundred Ninety Five Dollars and Nineteen Cents
Public Function NumToDol(N) As String
Words = Array("", " One", " Two", " Three", " Four", " Five", " Six", " Seven", " Eight", " Nine", " Ten", " Eleven", " Twelve", " Thirteen", " Fourteen", " Fifteen", " Sixteen", " Seventeen", " Eighteen", " Nineteen", "", "", " Twenty", " Thirty", " Forty", " Fifty", " Sixty", " Seventy", " Eighty", " Ninety", " Hundred", "", " Thousand", " Million", " Billion", " Trillion")
I = Int(N)
dd = Round(N - I, 2)
Dim D(1 To 2)
For j = 1 To 2
dd = dd * 10
D(j) = Int(dd)
dd = dd - Int(dd)
Next
If I = 0 Then L$ = "Zero"
If I > 0 Then
Dim G(5, 3) As Integer
For j = 1 To 5
For k = 3 To 1 Step -1
I = I / 10
G(j, k) = (I - Int(I)) * 10
I = Int(I)
Next
Next
For j = 5 To 1 Step -1
If G(j, 1) + G(j, 2) + G(j, 3) = 0 Then
Else
If G(j, 1) > 0 Then L$ = L$ & Words(G(j, 1)) & Words(30)
If G(j, 2) = 1 Then
L$ = L$ & Words(G(j, 3) + 10)
Else
L$ = L$ & Words(G(j, 2) + 20) & Words(G(j, 3))
End If
L$ = L$ & Words(j + 30)
End If
Next
End If
If D(1) = 1 Then
F$ = Words(D(2) + 10)
Else
If D(1) > 0 Then F$ = F$ & Words(D(1) + 18)
If D(2) > 0 Then F$ = F$ & Words(D(2))
If D(1) = 0 And D(2) = 0 Then F$ = "no"
End If
NumToDol = Trim(L$) & " Dollars" & " and " & F$ & " Cents"
End Function
Sorry,the previous message was published incomplete.
I retry to post it.
I wrote this.
It works with numbers 0 Then
Dim G(5, 3) As Integer
For j = 1 To 5
For k = 3 To 1 Step -1
I = I / 10
G(j, k) = (I - Int(I)) * 10
I = Int(I)
Next
Next
For j = 5 To 1 Step -1
If G(j, 1) + G(j, 2) + G(j, 3) = 0 Then
Else
If G(j, 1) > 0 Then L$ = L$ & Words(G(j, 1)) & Words(30)
If G(j, 2) = 1 Then
L$ = L$ & Words(G(j, 3) + 10)
Else
L$ = L$ & Words(G(j, 2) + 20) & Words(G(j, 3))
End If
L$ = L$ & Words(j + 30)
End If
Next
End If
If D(1) = 1 Then
F$ = Words(D(2) + 10)
Else
If D(1) > 0 Then F$ = F$ & Words(D(1) + 18)
If D(2) > 0 Then F$ = F$ & Words(D(2))
If D(1) = 0 And D(2) = 0 Then F$ = "no"
End If
NumToDol = Trim(L$) & " Dollars" & " and " & F$ & " Cents"
End Function
Please sir help me to spell number to words in Omani rial.
1 OMR=1000 Baiza
so I need to change like this
234.345
I mean i need to spell 3 digit after decimal as Omani Rial is prounced like this.
Thanks in advance.
Dear Sir
I have been working in Oman and I Need the VBA code for Omani currency. First I would like to give some information.
Currency name=Omani Rial
1 Omani Rial=1000 Baiza
So I need it in international system. I have been facing the problem like -1256475.256. how to spell after decimal sir? Please send me the vba code in my mail id-purushottamthapa568@gmail.com. I would you be very grateful .
Ah...that's so good for share your such a cool informative method. It benefits for me to apply to my job.
Although, I have been using Excel program for my office work, yet I think I still know it too little if compare to yours.
Thanks,
is ther eany way to dynamically change the currency depending on the currency format in the reference cell ..
How to Use TRIM formula Please Help Me
How I can change numeric to word in rupees please solve my problem thanks
When I wrote =spellnumber(A2)
It shows name error.
how to convert 1,342.50 in to words as per indian currency
In Indian currency format we write Rupees One crore ninety nine lac ninety nine thousand nine hundred ninety nine and ninety nine paisas. In your formula we need little change. Million, billion and trillion should be replaced with Lacs and Crores in proper places. Here is some tips:
1 million = 10 lacs
10 million = 1 crore.
We can write lacs limited up to ninety nine lac but crore is ulimited up to some extent. E.g. 100 crores, 10000 crores etc.
Can you please take some burden to upgrade your version for indian format. Thanks in advance.
Good evening Sir,
How to Covert date of birth into worlds
Exm: 02/02/1966
Second february ninteen sixty six
is any formula pl
Hi, I have made a slight change to the code and it allows me to spellnumber as eg.Two hundreds and Cents Thirteen Only. However, i am facing a problem when the amount turns out with 3 decimal places e.g. $200.137. I need the spell number to be $200.14 and not spelled as $200.13. Could you help? Thank you very much.
Very Very help full this method thank you very much
Hello. I want to calculate numeric to inward and linking in The Excel2010. How to possible please inform me by sending mail.
I want to convert number to word in nepali format .But I don't know how to create formula in excel sheet.
This is to inform you that I m using Ms office 7 . The issue is that when i use any amount in excel , it gets converted into words only in the file which i have saved it.
When I open a new fle, it doesn't automatically accept it. I have to use the formula again in the new sheet to convert it. So, is there any setting in Ms office 7 that I can convert numbers into alphabetical while writing amount in excel in each and every file.
For Eg:
10000 - Ten Thousand.
Plz help.
(100000=one Million) need this formula (No need currency)
Need this sample spellnumber, please help anybody me, for share spell number in my email, exp: 125000=Twelve milion five thousand this formula
"Reverse conversion - English words into numbers
Frankly, I can't imagine why you may need it. Just in case... :)"
Thank you so much - this was exactly what we were looking for!!! Kudos!
Hi!
I still am not able to convert figures in words. Can you please send me the formula in excel sheet without any currency.
Thanks
Hi Sir,
Please send me formula for write only for the words without dollars ans cents
Greetings Sir.
I want code for text of spell number in Indian Rupees and Paisas with shoing Rupees at start of text figure. for example
1000.50 is to text as
Rupees One Thousand and fifty paisas only.
Thanks for your urgent reply
Alexandre,
Thank you for your help! This article is excellent!
I have only one question. The formula is working perfect when I have the spreadsheet saved in my own hard disk, but when I save the file on my share drive the formula doesn't work. Is there any way to fix it?
all formulas showing error
these formulas are not working