How to convert number to words in Excel, comments page 18

Comments page 18. Total comments: 530

sandip sutariya says:
2015-08-11 at 11:01 am

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.
shamim says:
2015-07-04 at 9:09 am

(100000=one Million) need this formula (No need currency)
shamim says:
2015-07-04 at 9:06 am

Need this sample spellnumber, please help anybody me, for share spell number in my email, exp: 125000=Twelve milion five thousand this formula
Anon says:
2015-06-15 at 8:40 pm

"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!
Ashish Ranjan says:
2015-06-12 at 11:05 am

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
Nousheer says:
2015-05-20 at 11:30 am

Hi Sir,

Please send me formula for write only for the words without dollars ans cents
azhar siddique says:
2015-04-18 at 7:08 am

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
Veronika says:
2015-04-07 at 7:51 pm

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?
Naeem Ali says:
2015-04-04 at 11:58 am

all formulas showing error
naeem ali says:
2015-04-04 at 11:57 am

these formulas are not working
Michelle says:
2015-03-31 at 6:16 pm

Thank you so much! Works like a charm!!!!!! (=spellnumber) - Just what the doctor ordered!
nauman says:
2015-03-11 at 9:32 am

I want amount 500.260 as " Five hundered Riyal and 260 Baisa Only" How can i get do it decimals till 3 digits and also in numeric.
jawanova says:
2015-03-03 at 11:21 pm

I would like complete this using the formula only (no macro) and also have the text read the cents as "55/100 DOLLARS". So, for example, $7,547.55 = "SEVEN THOUSAND FIVE HUNDRED FORTY-SEVEN AND 55/100 DOLLARS" Can anyone help with that? I'd prefer not to use a macro, if possible.
TRUE USER says:
2015-02-21 at 7:23 am

sir i got that formula and its works at once.but when i close excel and reopen then #name error comes and format formula has been out
Khushhal Togra says:
2015-02-20 at 6:35 am

Hi,

I have an Problem. the Number convert into word the following example. I want (two lakh four hundred seventy four dollars and 24 Cents). Please help me.

2,00,474.25
Two Hundred Thousand Four Hundred Seventy Four Dollars and Twenty Five Cents
rich says:
2015-02-18 at 2:25 am

hi how will i convert 100.47 into "one hundred & 47/100 Only"

i tried suggested response but all of them are not working did i missed something. can i have the detailed steps

thank you
1. syra mae says:
  2022-08-09 at 8:02 am
  
  hi! just wondering if this is already solved can i have the complete formula for this? thannk you so much
aadil says:
2015-02-12 at 6:29 am

sir i got that formula and its works at once.but when i close excel and reopen then #name error comes and format formula has been out
Anonymous says:
2015-02-11 at 1:45 pm

In Indian Format you can convert up to neel rupee
&
In million format you can convert up to trillion dollar

You can change your currency by find and replace rupee-paise or dollar-cent to any other currency
Or
You can also use it without any currency just find and replace rupee-paise or dollar-cent with blank (spacebar)
Anonymous says:
2015-02-11 at 1:37 pm

in Million Format (Excel Formula)

=TRIM(IF(C5>=10^14," "&CHOOSE(FLOOR(MOD(C5,10^15)/10^14,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),"")&IF(MOD(C5,10^15)>=10^14," Hundred"," ")&" "&IF(MOD(C5,10^14)>=2*10^13," "&CHOOSE(FLOOR(MOD(C5,10^14)/10^13,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C5,10^14),10^13)>=10^12," "&CHOOSE(FLOOR(MOD(MOD(C5,10^14),10^13)/10^12,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C5,10^14)>=10^12," "&CHOOSE(FLOOR(MOD(C5,10^14)/10^12,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C5,10^15)>=10^12," Trillion"," ")&" "&IF(C5>=10^11," "&CHOOSE(FLOOR(MOD(C5,10^12)/10^11,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),"")&IF(MOD(C5,10^12)>=10^11," Hundred"," ")&" "&IF(MOD(C5,10^11)>=2*10^10," "&CHOOSE(FLOOR(MOD(C5,10^11)/10^10,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C5,10^11),10^10)>=10^9," "&CHOOSE(FLOOR(MOD(MOD(C5,10^11),10^10)/10^9,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C5,10^11)>=10^9," "&CHOOSE(FLOOR(MOD(C5,10^11)/10^9,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C5,10^12)>=10^9," Billion"," ")&" "&IF(C5>=10^8," "&CHOOSE(FLOOR(MOD(C5,10^9)/10^8,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),"")&IF(MOD(C5,10^9)>=10^8," Hundred"," ")&" "&IF(MOD(C5,10^8)>=2*10^7," "&CHOOSE(FLOOR(MOD(C5,10^8)/10^7,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C5,10^8),10^7)>=10^6," "&CHOOSE(FLOOR(MOD(MOD(C5,10^8),10^7)/10^6,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C5,10^8)>=10^6," "&CHOOSE(FLOOR(MOD(C5,10^8)/10^6,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C5,10^9)>=10^6," Million"," ")&" "&IF(C5>=10^5," "&CHOOSE(FLOOR(MOD(C5,10^6)/10^5,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),"")&IF(MOD(C5,10^6)>=10^5," Hundred"," ")&" "&IF(MOD(C5,10^5)>=20000," "&CHOOSE(FLOOR(MOD(C5,10^5)/10^4,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C5,10^5),10^4)>=10^3," "&CHOOSE(FLOOR(MOD(MOD(C5,10^5),10^4)/10^3,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C5,10^5)>=10^3," "&CHOOSE(FLOOR(MOD(C5,10^5)/10^3,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C5,10^6)>=10^3," Thousand"," ")&IF(C5>=10^2," "&CHOOSE(FLOOR(MOD(C5,10^3)/10^2,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),"")&IF(MOD(C5,10^3)>=10^2," Hundred"," ")&IF(MOD(C5,10^2)>=20," "&CHOOSE(FLOOR(MOD(C5,10^2)/10,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C5,10^2),10)>=1," "&CHOOSE(FLOOR(MOD(MOD(C5,10^2),10),1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C5,10^2)>=1," "&CHOOSE(FLOOR(MOD(C5,10^2),1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(C5=1," Dollar","")&IF(C5>1," Dollars","")&IF(AND(C5>0.99,MOD(RIGHT((ROUND(C5,2))*100,2),10^2)>0)," and","")&IF(MOD(RIGHT((ROUND(C5,2))*100,2),10^2)>=20," "&CHOOSE(FLOOR(MOD(RIGHT((ROUND(C5,2))*100,2),10^2)/10,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(RIGHT((ROUND(C5,2))*100,2),10^2),10)>=1," "&CHOOSE(FLOOR(MOD(MOD(RIGHT((ROUND(C5,2))*100,2),10^2),10),1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(RIGHT((ROUND(C5,2))*100,2),10^2)>=1," "&CHOOSE(FLOOR(MOD(RIGHT((ROUND(C5,2))*100,2),10^2),1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(RIGHT((ROUND(C5,2))*100,2),10^2)=1," Cent","")&IF(MOD(RIGHT((ROUND(C5,2))*100,2),10^2)>1," Cents",""))
1. Saleh says:
  2016-12-02 at 3:42 am
  
  i wanna add one more zero on the cents to written 0.100 as hundred cents
Anonymous says:
2015-02-11 at 1:36 pm

in Indian Format (Excel Formula)

=TRIM(IF(C6=1," Rupee","")&IF(C6>1," Rupees","")&IF(MOD(C6,10^15)>=(2*(10^14))," "&CHOOSE(FLOOR(MOD(C6,10^15)/10^14,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C6,10^15),10^14)>=10^13," "&CHOOSE(FLOOR(MOD(MOD(C6,10^15),10^14)/10^13,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C6,10^15)>=10^13," "&CHOOSE(FLOOR(MOD(C6,10^15)/10^13,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C6,10^15)>=10^13," Neel"," ")&IF(MOD(C6,10^13)>=(2*(10^12))," "&CHOOSE(FLOOR(MOD(C6,10^13)/10^12,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C6,10^13),10^12)>=10^11," "&CHOOSE(FLOOR(MOD(MOD(C6,10^13),10^12)/10^11,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C6,10^13)>=10^11," "&CHOOSE(FLOOR(MOD(C6,10^13)/10^11,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C6,10^13)>=10^11," Kharab"," ")&IF(MOD(C6,10^11)>=(2*(10^10))," "&CHOOSE(FLOOR(MOD(C6,10^11)/10^10,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C6,10^11),10^10)>=10^9," "&CHOOSE(FLOOR(MOD(MOD(C6,10^11),10^10)/10^9,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C6,10^11)>=10^9," "&CHOOSE(FLOOR(MOD(C6,10^11)/10^9,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C6,10^11)>=10^9," Arab"," ")&IF(MOD(C6,10^9)>=200000000," "&CHOOSE(FLOOR(MOD(C6,10^9)/10^8,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C6,10^9),10^8)>=10^7," "&CHOOSE(FLOOR(MOD(MOD(C6,10^9),10^8)/10^7,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C6,10^9)>=10^7," "&CHOOSE(FLOOR(MOD(C6,10^9)/10^7,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C6,10^9)>=10^7," Crore"," ")&IF(MOD(C6,10^7)>=2000000," "&CHOOSE(FLOOR(MOD(C6,10^7)/10^6,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C6,10^7),10^6)>=10^5," "&CHOOSE(FLOOR(MOD(MOD(C6,10^7),10^6)/10^5,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C6,10^7)>=10^5," "&CHOOSE(FLOOR(MOD(C6,10^7)/10^5,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C6,10^7)>=10^5," Lakh"," ")&IF(MOD(C6,10^5)>=20000," "&CHOOSE(FLOOR(MOD(C6,10^5)/10^4,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C6,10^5),10^4)>=10^3," "&CHOOSE(FLOOR(MOD(MOD(C6,10^5),10^4)/10^3,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C6,10^5)>=10^3," "&CHOOSE(FLOOR(MOD(C6,10^5)/10^3,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(MOD(C6,10^5)>=10^3," Thousand"," ")&IF(C6>=10^2," "&CHOOSE(FLOOR(MOD(C6,10^3)/10^2,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),"")&IF(MOD(C6,10^3)>=10^2," Hundred"," ")&IF(MOD(C6,10^2)>=20," "&CHOOSE(FLOOR(MOD(C6,10^2)/10,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(C6,10^2),10)>=1," "&CHOOSE(FLOOR(MOD(MOD(C6,10^2),10),1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(C6,10^2)>=1," "&CHOOSE(FLOOR(MOD(C6,10^2),1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(AND(C6>0.99,MOD(RIGHT((ROUND(C6,2))*100,2),10^2)>0)," and","")&IF(MOD(RIGHT((ROUND(C6,2))*100,2),10^2)>0," Paise","")&IF(MOD(RIGHT((ROUND(C6,2))*100,2),10^2)>=20," "&CHOOSE(FLOOR(MOD(RIGHT((ROUND(C6,2))*100,2),10^2)/10,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(RIGHT((ROUND(C6,2))*100,2),10^2),10)>=1," "&CHOOSE(FLOOR(MOD(MOD(RIGHT((ROUND(C6,2))*100,2),10^2),10),1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine"),""),IF(MOD(RIGHT((ROUND(C6,2))*100,2),10^2)>=1," "&CHOOSE(FLOOR(MOD(RIGHT((ROUND(C6,2))*100,2),10^2),1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&IF(C6>0.01," Only",""))
1. Nitesh says:
  2017-04-11 at 7:01 am
  
  Thanks alot. It works without VBA and can be easily copied paste.
2. Prem Soni says:
  2016-09-02 at 5:28 am
  
  Much appriciated.
  I was looking for somthing like this ...and You made it.
  GOD Bless you!
3. Subash Chandra Pradhan says:
  2016-08-23 at 1:48 pm
  
  Am worried for long time how to solve it without macro or VB, but now am very helpful for using this formula in my spread sheet...
  Thanks a lot
4. Kunal says:
  2016-06-13 at 11:08 am
  
  Amazing & Excellent work. Working fine for me. Thanks a lot for the effort.
5. javed says:
  2016-05-25 at 12:24 pm
  
  This formula is not working so please correct formula and send on my Email Id, How to convert number in words forment, Like 700 = seven hunderd
6. Zaheer says:
  2015-06-15 at 10:53 am
  
  Wah yar Zabardast.
7. Laxman KC says:
  2015-04-10 at 7:00 am
  
  Thank you very much for creation of Currency in to word Formula.
  
  it helps me 100% in my profession life..... which solution was searching last 2 years.
  Today, i achieved solution.
Vipin says:
2015-01-31 at 5:25 am

How to insert Rupees instead of Dollar and Paise instead of Cent in the outcome from above =spellnumber() function ?
Keshav Gupta says:
2015-01-26 at 1:58 pm

By this Indian rupees and paise is not convert in words.Plz solve this problem.
Anonymous says:
2015-01-19 at 11:13 am

great it worked for me perfectly
Cathrine says:
2015-01-17 at 7:01 am

HI, im unable to understand and work the formula pls help..
Mukto Ahmed says:
2014-12-13 at 11:01 am

I want to convert numeric value with word form without any currency.
Pl help me
1. Tahir says:
  2016-08-25 at 10:25 am
  
  Dear, i also need same as you are demanding.please provide me same function if you have,
  thanks
thaipv says:
2014-12-11 at 3:41 pm

You can also do it by my function :

Option Explicit
Option Base 0
'Author: thaipv@live.com
'Date: 30/11/2014
'Reference: https://support.microsoft.com/kb/95640
'More: http://www.techonthenet.com/excel/formulas/curr_to_words.php
Function READNUMBER(ByVal CNUMBER, Optional UPPER As Boolean = True) As String
Dim DIGIT, ATEEN, ATENS, PLACE(13), READ1__$, READ_23$, READ123$
Dim NUMBER1 As Byte, NUMBER2 As Byte, NUMBER3 As Byte, V As Byte

DIGIT = Array("", " one", " two", " three", " four", " five", " six", " seven", " eight", " nine")
ATEEN = Array(" ten", " elevent", " twelve", " thirteen", " fourteen", " fifteen", " sixteen", " seventeen", " eighteen", " nineteen")
ATENS = Array("", "", " twenty", " thirty", " forty", " fifty", " sixty", " seventy", " eighty", " ninety")
PLACE(1) = " trillion,": PLACE(4) = " billion,"
PLACE(7) = " million,": PLACE(10) = " thousand,"

If Trim$(CNUMBER) = "" Then
READNUMBER = ""
ElseIf Not IsNumeric(CNUMBER) Then
READNUMBER = "(ò_ó) Hmm, It is too embarrassing! XA can not read this number: " & "'" & CNUMBER & "'"
ElseIf CNUMBER 10 ^ 15 Then
READNUMBER = "(ò_ó) Hmm, It is too embarrassing! This number is too large to read."
Else
'// Doc dau am/duong cua so tien va xy ly so tien truoc khi doc//
READNUMBER = IIf(Round(CNUMBER, 0) < 0, "minus", "")
CNUMBER = Round(Abs(CNUMBER), 0): CNUMBER = "000000000000000" & CNUMBER
CNUMBER = Replace$(CNUMBER, ",", ""): CNUMBER = Right$(CNUMBER, 15)

'// Bat dau doc so //
For V = 1 To 13 Step 3
NUMBER1 = Mid$(CNUMBER, V, 1)
NUMBER2 = Mid$(CNUMBER, V + 1, 1)
NUMBER3 = Mid$(CNUMBER, V + 2, 1)
READ123 = ""
READ1__ = IIf(NUMBER1 = 0, "", DIGIT(NUMBER1) & " hundread")
Select Case NUMBER2
Case 0: READ_23 = DIGIT(NUMBER3)
Case 1: READ_23 = ATEEN(NUMBER3)
Case Else: READ_23 = ATENS(NUMBER2) & DIGIT(NUMBER3)
End Select
READ123 = READ1__ & READ_23
READNUMBER = Trim$(READNUMBER & IIf(Len(READ123) = 0, "", READ123 & PLACE(V)))
Next V

'// Xu ly (nhung) dau phay (",") du thua va VIET HOA chu dau tien //
READNUMBER = IIf(Right$(READNUMBER, 1) = ",", Left$(READNUMBER, Len(READNUMBER) - 1), READNUMBER)
READNUMBER = IIf(UPPER = True, UCase$(Left$(READNUMBER, 1)) & Mid$(READNUMBER, 2), READNUMBER)
End If
End Function
Mohammed Iftekhar Ahmed says:
2014-12-06 at 9:26 am

Dear
We are working in Oman .SO can you please send us the VBA MICRO code for Oman Currency.We write omani currency in three decimal palce
e.g 450.560 four hundred fifty Rials and five hundred sixty Baiza.
Pease help me to convert nuemerical Omani currencyin word in excel.
WITH REGARDS
MOHAMMED IFTEKHAR AHMED
Mohammed Hussain says:
2014-12-03 at 6:07 pm

DEAR FRIENDS, CAN I HAVE THE SAME THAT CAN AUTO SELECT CURRENCY ,,

SOMETIME IT MAY BE IN USD, EUR, AED, SAR, KWD
AND SO ON . SO HOW TO ENABLE THE FORMULA FOR MULTIPLE CURRENCY ..

THANKS
PABAN JAISWAL says:
2014-12-01 at 7:53 pm

THANKS
sam says:
2014-12-01 at 10:01 am

how to the change the format to Lakh & Crores instead of Million & Trillion
1. Samir says:
  2015-05-28 at 11:38 am
  
  I need your help,
  Please know me Lac & Croers formula,
  very urgent your co operation.
  Best Regards
  Samir.
  Dhaka.
Anwar says:
2014-11-24 at 8:15 am

Hi! Thanks for the formula. It works, I have created the VB formula. But I Just need "Ten Thousand" rather than "Ten Thousand Dollors And None Cents?"
Ricardo Zavala says:
2014-11-24 at 4:44 am

I need help from some excel masters. I need excel convert from numbers like $1234.50 ...to text, but writing the cents in the form of 50/100 and word USD at the end...I would really apreciate somebody share this trick please.
1. MEEE says:
  2016-10-20 at 1:17 pm
  
  Hi have u solve this problem? Help plssss
jessica says:
2014-11-06 at 7:17 am

Hi, how can I convert 1,547.50 into "One thousand five hundred forty seven and cents fifty only"?
Beejay says:
2014-11-03 at 3:57 pm

Very great. Kudos to all who contributed to this knowledge sharing medium. However, it can be improved upon by adding seperators in form of commas ','. For example, converting $1,500.00 into words would be 'One thousand five hundred dollars' rather than 'One thousand, five hundred dollars'.
SAADULLAH says:
2014-10-29 at 6:52 am

GREAT HELP . THANKS

THE WORD """DOLLARS""" AND """CENTS"""

YOU CAN ALSO USE THE CURRENCY OF YOUR COUNTRY LIKE

I USE................. """RUPEES""" AND """PAISA"""

AND ITS WORKING FINE..............

FOR PAKISTANI CURRENCY..............
Renju Kuriakose says:
2014-10-28 at 12:22 pm

how can i change from Dollar to Saudi Riyal
1. SAADULLAH says:
  2014-10-29 at 6:53 am
  
  JUST SEARCH IN VB ""DOLLARS""""" REPLACE WITH """SAUDI RAYAL"""
  
  SIMPLE
olu says:
2014-10-22 at 6:58 am

plsss....I tried it.... but I got error message... LOOP WITHOUT DO.....plss..kindly send the excel file to my mail..... ifelekods @gmail.com. thanks
Gil says:
2014-10-16 at 2:11 pm

I need to convert on checks a number without the dollar sign to words with a dollar sign. Can you send me a spread sheet with a working module. I copied and pasted but get a pop up on the VBA. Thanks
1. dagm says:
  2014-10-17 at 2:15 pm
  
  USE Rahim Zulfiqar AlI'S FORMAUL AND COPY PASTE THE RESULT AS TEXT AND MATCH IT WITH THE ADDITIONAL THAT YOU WANT IT BE REDA WITH
cody says:
2014-10-16 at 12:59 pm

Hi there,

I really need to fix the format on the big numbers to say "thiry thousand five hundred AND Ninty dollars and fifty four cents"
I need the AND after the five hundred... please help, I just what to know where to fix the code...
Hamiza says:
2014-09-25 at 3:18 am

thanks it works
Hamiza says:
2014-09-24 at 10:25 pm

Hi Kudzi

Tried yr formula but was fail. What do you mean by "NUMBERVALUE"?

Best Regards.
satish says:
2014-09-24 at 8:24 am

we convert in indian currency e.g 12(tweleve) in this way not dollar
yenyen says:
2014-09-22 at 4:13 am

Superb
yenyen says:
2014-09-22 at 3:48 am

how if we don't want the words "dollars" in our converted sentences.. Pls show me the module, Thank you so much.
1. sakhone says:
  2016-08-07 at 12:01 pm
  
  if i no need "dollars" what should i do ?
  the thing i want (1001.10=One thousand one point ten) who know
  pls help me.
  thanks
kudzi says:
2014-09-19 at 5:59 pm

If you have added the add in like Nick T instructed above, but you say you are filling a checque in excel and you would want

e.g 4000 to be "four thousand dollars only" and not "four thousand dollars and no cents" but you would also want 4000.36 to be "four thousand dollars and thirty six cents only" when there are cents added.

lets say the number you want to convert is in cell "B" use the following formula

'=IF(NUMBERVALUE(RIGHT(B6,2),".",",")>0,CONCATENATE(UPPER(SpellNumber(B6))," ONLY"),CONCATENATE(LEFT(UPPER(SpellNumber(B6)),LEN(UPPER(SpellNumber(B6)))-12)," ONLY"))
kudzi says:
2014-09-19 at 4:23 pm

thanks Nick T
Nick T says:
2014-09-09 at 12:51 pm

I came across an article on another site, to embed this function permanently into Excel, without it being a macro and creating opening and saving nightmares.

Similar process as listed above, and as you may have seen before, but with a twist...

>> Open a blank workbook in Excel
>> Hit ALT-F11
>> On the top menu, select Insert>Module
>> Copy and paste the above mentioned VBA code (from the original post, way up top)
>> Back in VBA, on the top menu, select File>Save Book#
>> Once in the Save As menu, go down to "Save as type:", click the down arrow, and select "Excel Add-In"
>> Type a file name of your choosing, (I chose SpellNumber) and choose a file location you'll remember. (the predefined location will work just fine, but you may want to note the location, just in case.
>> Close out of the VBA editor
>> On the top main Excel menu, select File>Options
>> In the Excel Options menu, on the left side, select "Add-Ins"
>> In the Add-ins menu, at the bottom, under "Manage:" click the down arrow, and select "Excel Add-ins", and then click "Go..."
>> In the subsequent Add-ins menu, on the right side, click "Browse..."
>> In the Browse pop-up, you may or may not see the add-in that you previously created and saved. If you see it, select it and click OK. If you do not see it, navigate to the location where you saved it, then select the file and click OK.
>> Now back in the previous Add-ins menu, you will see your Add-in in the list. If it's box is not checked, click to check it at this time, then on the right, click OK.
>> Your Add-in will now load every time you open Excel, allowing you to use and perform this function all the time. Also, it is now an add-in, not a macro, so will not create the hassles macro-enabled workbooks carry.
>> To actually use the function, simply start typing =Spellnu the function should auto populate. Double-click the popup, select the cell you want spelled out, close the parenthesis ), and voila!
1. Knightven7 says:
  2016-12-01 at 9:03 am
  
  Indeed! It works!
  
  Thanks for this!
2. AranFa says:
  2016-11-17 at 11:47 am
  
  Thank you NickT, this helped me at work a lot. I have a question tho, I've been playing with the macro functions but i don't seem to be able to get the fills/cents in this format "50/100" "30/100" "89/100" do you have a function i can use for it?
  In the link https://goo.gl/tdBmGQ is the current macro i used as i don't want any currency, also i wanted the word only at the end but i manage that just adding & only at the end it works as well, so not too important that one.
  I would really appreciate if you could help me out with that function.
  
  Many many thanks!!!!
3. nayan says:
  2016-05-30 at 7:28 am
  
  Dear Mr. Nick T, What should I change in this formula if I Have to write the word for example Taka 9,875 (Taka Nine Thousand Eight Hundred and Seventy Five Only ) ? would You likely to help me to get rid off it ? Thanks
4. MG says:
  2015-07-03 at 6:07 pm
  
  Thnku.. Nick T...It works..
  1. anne says:
    2016-01-26 at 7:41 am
    
    nick how can i change the currency into peso..
    
    thank you.
    1. jv says:
      2016-01-29 at 8:38 am
      
      Hello change all "dollars" into pesos
      
      works for me
hazem says:
2014-08-31 at 5:51 am

your solution is amazing but i wonder if i just want the number as it is without dollars without saudi rayal without any currency name , how can i do that in the module
hui says:
2014-08-28 at 11:05 pm

if my number is $500.07 and my word want to convert to "Say Dollars Five Hundreds and cents Seven Only). What is the format for this?
1. hui says:
  2014-09-07 at 10:43 pm
  
  Thanks for your help...
2. Alexander says:
  2014-08-29 at 1:47 pm
  
  You need to customize the macro a little bit. I am sorry all our technicians are overloaded with work at the moment and can't help you with this. Please look for the solution on these forums: http://www.Mrexcel.com or http://www.excelforum.com
azeem says:
2014-08-18 at 1:51 pm

can you please provide me the easiest way to find spellnumber to convert numbers to words

Comments on: Two best ways to convert numbers to words in Excel

Comments page 18. Total comments: 530