How to spell out or convert numbers to English words in Excel?

Supposing you have a lot of price amount numbers, and now you need to convert or spell out them to text strings. For example, convert 123.55 to the English words one hundred twenty-three dollars and fifty five cents. In Excel there are no effective facility to solve this problem but using the long and complex VBA code. In this article, I will introduce you some methods to deal with it.

Spell out or convert numbers to English words with VBA code

Spell out or convert numbers to English words with Kutools for Excel


arrow blue right bubble Spell out or convert numbers to English words with VBA code


The following long VBA code can help you to spell out numbers to text strings. Do as follows:

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following macro in the Modulewindow.

Function SpellNumberToEnglish(ByVal pNumber)
'Updateby20131113
Dim Dollars, Cents
arr = Array("", "", " Thousand ", " Million ", " Billion ", " Trillion ")
pNumber = Trim(Str(pNumber))
xDecimal = InStr(pNumber, ".")
If xDecimal > 0 Then
    Cents = GetTens(Left(Mid(pNumber, xDecimal + 1) & "00", 2))
    pNumber = Trim(Left(pNumber, xDecimal - 1))
End If
xIndex = 1
Do While pNumber <> ""
    xHundred = ""
    xValue = Right(pNumber, 3)
    If Val(xValue) <> 0 Then
        xValue = Right("000" & xValue, 3)
        If Mid(xValue, 1, 1) <> "0" Then
            xHundred = GetDigit(Mid(xValue, 1, 1)) & " Hundred "
        End If
        If Mid(xValue, 2, 1) <> "0" Then
            xHundred = xHundred & GetTens(Mid(xValue, 2))
        Else
            xHundred = xHundred & GetDigit(Mid(xValue, 3))
        End If
    End If
    If xHundred <> "" Then
        Dollars = xHundred & arr(xIndex) & Dollars
    End If
    If Len(pNumber) > 3 Then
        pNumber = Left(pNumber, Len(pNumber) - 3)
    Else
        pNumber = ""
    End If
    xIndex = xIndex + 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
SpellNumberToEnglish = Dollars & Cents
End Function
Function GetTens(pTens)
Dim Result As String
Result = ""
If Val(Left(pTens, 1)) = 1 Then
    Select Case Val(pTens)
        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
Select Case Val(Left(pTens, 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(pTens, 1))
End If
GetTens = Result
End Function
Function GetDigit(pDigit)
Select Case Val(pDigit)
    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

3. Then save the code, and return to the worksheet, in the adjacent cell E1, enter the formula =SpellNumberToEnglish(D1), see screenshot:

doc-spell-out-numbers1

4. Then press Enter key, and select the cell E1, then drag the fill handle over to the range that contains this formula as you need. And all of the numbers have been spelt out to English words. See screenshot:

doc-spell-out-numbers2

Note: As they are formulas, when you need to copy and paste them, please paste as values.


arrow blue right bubble Spell out or convert numbers to English words with Kutools for Excel

Maybe the above long code can make you be mad, please don't worry, here I can give you an easy and quick way to solve it.

With the Kutools for Excel’s Spell Out Numbers function, you can quickly and conveniently convert the numbers to text strings.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

When you have installed Kutools for Excel, please do as following steps:

1. Select the range numbers that you want to spell out.

2. Click Kutools > Content > Spell Out Numbers. See screenshot:

doc spell out numbers 01

3. In the Spell Out Numbers dialog box, choose English from the Languages. And you can preview the results from the right Preview Pane. See screenshot:

doc spell out numbers 02

4. Then click Ok or Apply. And all of the price amount numbers have been converted to text strings in the original range.

doc-spell-out-numbers5 -2 doc-spell-out-numbers6

Note: If you need the Chinese price amount words, please click Chinese option from the Languages.

Click Spell Out Numbers to know more about this feature.

 

Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more btn download btn purchase

Comments  

Permalink 0 Anees
Its Really Cool. And Fount its easy to change the Word " Dollar and Send to Rupees or any other currency we want by Copy pasting the cod to any other new word page and replacing the Same.
2013-12-03 06:22 Reply Reply with quote Quote
Permalink +4 i am not getting
I am not getting this formula in my Sheet, Can you show me in detail
2014-02-01 04:47 Reply Reply with quote Quote
Permalink +2 heba
Thank you for your valuable information. I need to mention that it's Dirham and not dollar, how can i make it

Thank you in advance
2014-02-19 08:40 Reply Reply with quote Quote
Permalink +1 jabesh
Please change all the words ~dollar/dollars " and ~cent/cents" in the code into your currency name.
2014-02-26 19:45 Reply Reply with quote Quote
Permalink 0 adel
I tried this and worked for me...
go the module, ctrl F to find >>> then in the find put Dollar and then go to replace (in the same popup box) and put Dirham,
it will work
2016-10-19 10:33 Reply Reply with quote Quote
Permalink +3 know it all
Problem on rounding off with numbers.

Example is in my general data is 50.576 but when I rounded it off and become 50.58, Words doesn't change/convert according to the new value.
2014-02-21 08:33 Reply Reply with quote Quote
Permalink +1 jabesh
It's a well-working code. Thanks a lot.
2014-02-26 19:49 Reply Reply with quote Quote
Permalink +5 Mahesh Giri
Its is a very good formula, But I need the words in Indian formats
2014-03-03 11:10 Reply Reply with quote Quote
Permalink +1 santosh
plx make me clear that how can I see it in my country's currency format i.e. Rupees in place of Dollars and Paisa in place of Cents.
2014-03-04 06:38 Reply Reply with quote Quote
Permalink +2 ATUL
dEAR SIR,


Its is a very good formula, But I need the words in Indian formats
PLEASE ADVICE
2014-03-18 11:18 Reply Reply with quote Quote
Permalink +3 azhar
is it possible to get data as 100th after decimal, for example .100 answer shout be as 100 instead of ten
2014-03-19 20:18 Reply Reply with quote Quote
Permalink +3 Rajan
thanks for the formula, however, is it possible to get the word "Dollar/Rupees" as a prefix i.e. Rupees One thousand .... and Paisas thirty only.

would really appreciate your response.
2014-03-24 09:23 Reply Reply with quote Quote
Permalink +1 Rajendra singh
How Can i change amount in english words in indian currency
2014-03-26 09:20 Reply Reply with quote Quote
Permalink -2 shreesh garg
copy the above code language in a word sheet

replace word "dollar" with "Rupees"
Then
Replace word "cents" with "Paisa"

go back to excel file

press alt+F11

insert>>> module >> paste the entire word file till "end function"

do .....=SpellNumberToEnglish(cellref)

& you are good to go
2014-04-17 06:16 Reply Reply with quote Quote
Permalink +5 Firash
Hi Sir,

I tried to save the macro as you mentioned above. and it is working fine. but if i close the excel and open a new sheet, it is not working . pls help
2014-06-29 07:33 Reply Reply with quote Quote
Permalink 0 SANTHOSH KONDURU
HELLO
JUS YOU CAN INSTALL SPEL CURR ADDIN YOU CAN CONVERT :) :) :lol:
2016-01-19 14:09 Reply Reply with quote Quote
Permalink +1 Hameed
Thaks a lot, could you please let me now how can i get indian format(Rupees)
2014-03-26 10:00 Reply Reply with quote Quote
Permalink 0 RICK
doesn't work. pop up says class not registered. no option to choose language. error code
2014-03-29 16:52 Reply Reply with quote Quote
Permalink -1 Abhishek
wow great for the stuff i have been looking for a week. It works great.

Thanks a lot
2014-04-09 07:38 Reply Reply with quote Quote
Permalink +2 belle
its really helpful, really really big thanks :-)
2014-04-20 19:18 Reply Reply with quote Quote
Permalink 0 PAWAN
THNX ATONE FOR SUCH TIPS
2014-04-23 10:36 Reply Reply with quote Quote
Permalink 0 Abdul Basit
I have conducted a research and could not be able to convert into Pakistan currency system, as we people use this format. 1,00,00,00,00,0 00.00 but excel use this format 1,000,000,000,0 00. and the code is in million and trillion formula. I tried to change lack, karor, arab and kharab instead of million, billion and trillion, but it will change only words and the system will remain same. like after change it will show this one. 100,000,000 it should be hundred million, but it will be shown hundred lakhs.If some one can help me i shall be thankfull to you.
2014-04-24 10:24 Reply Reply with quote Quote
Permalink -1 vishal shah
I want to convert Metric weight from numbers to words.

eg.
1. 10.50 Metric Tons (MT) should write as "10 Tons and 500 kgs"
2. 12.345 MT = Twelve Tons and Three hundred Forty Five Kgs

Need 3 decimal places atleast and 4 is even better.
max 9999.9999 is how i want.

Can someone please help?
2014-05-05 09:57 Reply Reply with quote Quote
Permalink 0 Islam
Please if you found the way... please email me

Thanks
2016-06-19 10:45 Reply Reply with quote Quote
Permalink 0 Islam
If you found please email me
2016-06-19 10:46 Reply Reply with quote Quote
Permalink +1 Khalid
Fantastic. Thanks to Extend Office
2014-05-09 16:16 Reply Reply with quote Quote
Permalink 0 HASNAIN SHAHID
Thanks for this Help
its working :-)
2014-05-13 06:49 Reply Reply with quote Quote
Permalink 0 SATHISH
hai, it was superb. but anyone help me to execute this as it is excluding money(dollar,ce nt,rupee,paisa, etc.)
2014-06-12 11:43 Reply Reply with quote Quote
Permalink +12 roy
can anyone help me to spell only whole number not cents. ex. 125,685.25 spells as ONE HUNDRED TWENTY FIVE THOUSAND SIX HUNDRED EIGHTY FIVE & 25/100 ONLY. that's what i want please help me.

thank you so much
2014-06-19 08:18 Reply Reply with quote Quote
Permalink +1 Jairo Moreno
Quoting roy:
can anyone help me to spell only whole number not cents. ex. 125,685.25 spells as ONE HUNDRED TWENTY FIVE THOUSAND SIX HUNDRED EIGHTY FIVE & 25/100 ONLY. that's what i want please help me.

thank you so much

Yes, I was able to make it spell out everything but the cents, and give the cents in a 25/100 Cents format, instead of the "and 25 Cents" as given in the code. The first step is to declare a variable pCents, right where Cents is first declared. The next step is to insert a line of code just after the first time the variable Cents is calculated, and that line of code is "pCents = Left(Mid(pNumbe r, xDecimal + 1) & "00", 2)" not including the " at beginning and end. Then where Cents is about to be "printed out", replace the ending Cents with pCents and add "/100 Cents" That line should look like this: Cents = " and " & pCents & "/100 Cents" I may explain it better if there is an interest.
2016-02-18 16:02 Reply Reply with quote Quote
Permalink 0 Staff
Quoting Jairo Moreno:
Quoting roy:
can anyone help me to spell only whole number not cents. ex. 125,685.25 spells as ONE HUNDRED TWENTY FIVE THOUSAND SIX HUNDRED EIGHTY FIVE & 25/100 ONLY. that's what i want please help me.

thank you so much

Yes, I was able to make it spell out everything but the cents, and give the cents in a 25/100 Cents format, instead of the "and 25 Cents" as given in the code. The first step is to declare a variable pCents, right where Cents is first declared. The next step is to insert a line of code just after the first time the variable Cents is calculated, and that line of code is "pCents = Left(Mid(pNumber, xDecimal + 1) & "00", 2)" not including the " at beginning and end. Then where Cents is about to be "printed out", replace the ending Cents with pCents and add "/100 Cents" That line should look like this: Cents = " and " & pCents & "/100 Cents" I may explain it better if there is an interest.



THANKS A LOT.. IT WORKS LIKE WONDER.. :lol:
2017-05-22 03:43 Reply Reply with quote Quote
Permalink +1 Bilash
I need hepl on same issue "Example is in my general data is 50.576 but when I rounded it off and become 50.58, Words doesn't change/convert according to the new value".
2014-06-20 07:13 Reply Reply with quote Quote
Permalink 0 Sophany
I can use this code, but they haven't save and i didn't see what i have done with this code when i reopen the workbook.
2014-06-25 03:06 Reply Reply with quote Quote
Permalink -1 Bilash
Sophany: Plz save your file as a macro enable mode; hope it'll be work.
2014-06-25 07:05 Reply Reply with quote Quote
Permalink +1 Janine
This is awesome!! This is very helpful!
2014-07-09 17:33 Reply Reply with quote Quote
Permalink 0 Amar Srivastava
It's awesome....... this is useful for us.
2014-07-15 10:36 Reply Reply with quote Quote
Permalink 0 Amar Srivastava
it's very useful for us thanks it's awesome.
2014-07-15 10:37 Reply Reply with quote Quote
Permalink 0 Mikee
how can i use same module in access VBA code?
2014-07-18 13:03 Reply Reply with quote Quote
Permalink +1 Zakwan
Quoting Firash:
Hi Sir,

I tried to save the macro as you mentioned above. and it is working fine. but if i close the excel and open a new sheet, it is not working . pls help


I also faced same issue, any help please. thanks
2014-07-25 13:40 Reply Reply with quote Quote
Permalink 0 Anna
Got it! after you paste the program you have to press Alt+Q then save type the file name and select "SAVE AS TYPE" Excel Macro-Enabled Workbook (*.xlsm)..
2015-08-24 05:16 Reply Reply with quote Quote
Permalink 0 Dom
You have done a great work and is very useful for me, awesome! But here is my question. Since i don't need any dollar and cents, just need the number spelled out, how can I change it??
2014-08-31 17:02 Reply Reply with quote Quote
Permalink +2 gunaraj
thanks for the formula, however, is it possible to get the word "Dollar/Rupees" as a prefix i.e. Rupees One thousand .... and Paisas thirty only.
please help
2014-09-03 04:34 Reply Reply with quote Quote
Permalink 0 pingky
So Great! It helpful. But how can I put the word "Only" at the end.How to do. Following is our format.
***SINGAPORE DOLLARS SIX THOUSAND EIGHT HUNDRED AND FOURTEEN ONLY***
2014-09-05 08:30 Reply Reply with quote Quote
Permalink +1 Aleem
thank you really its very usefull
2014-10-23 07:58 Reply Reply with quote Quote
Permalink 0 Carol Khor
I need the module code for spell number to change

1,234,567.89
into
RINGGIT MALAYSIA : ONE MILLION TWO HUNDRED THIRTY FOUR THOUSAND FIVE HUNDRED SIXTY SEVEN AND EIGHTY NINE CENTS ONLY

Thank you very much for your help.
2014-11-21 04:13 Reply Reply with quote Quote
Permalink 0 X2H
Hi Carol, did u manage to get an answer on how to change the spell number to our RM?
2015-07-23 03:44 Reply Reply with quote Quote
Permalink 0 TAPAN KUMAR JENA
can i change the value 3,25,655 as Three twenty five thousand six hundred fifty five to three lakh twenty five thousand six hundred fifty five. Please help thank you.
2015-01-08 07:45 Reply Reply with quote Quote
Permalink +1 ron
How can i improve this code that the result will be like this "One Hundred Ten Thousand and Twenty Cents (S110,000.20)"
2015-05-07 05:54 Reply Reply with quote Quote
Permalink +2 Gpaws1968
How can I convert a number value into words 0.04 to say four thousandths, without the Dollars and Cents
2015-05-09 15:10 Reply Reply with quote Quote
Permalink 0 saravanaprakash
How can i change the 169531535.25 - Sixteen Crores Ninety Five lakhs Thirty One Thousand Five Hundred Thirty Five and Twenty Five Paise
2015-05-21 06:02 Reply Reply with quote Quote
Permalink 0 JITESH AGARWAL
need help in excell 97-2003
2015-06-19 12:27 Reply Reply with quote Quote
Permalink 0 Qaiser Farman
Great tool...
Just one more thing, i dont want it to show this dollar and cents thing as i need only the words?
Any tool for that. Please??
2015-08-04 06:22 Reply Reply with quote Quote
Permalink 0 Skodin
Need this feature on your Android Mobile ?
You have problems writing your amounts in letters on checks? transfer form? rebate check form?
SpellMyAmount facilitate you all this; you enter the amount in numbers and it writes it for you in letters.
SpellMyAmount is an Android application available on Google Play!
Download it now: https://goo.gl/55u2YQ
On FaceBook: https://goo.gl/s1t89g
2015-08-11 23:10 Reply Reply with quote Quote
Permalink 0 Anna
this is also my concern..please help
2015-08-24 04:52 Reply Reply with quote Quote
Permalink +2 Mujeeb Ahmed
Dear, Sir I have been getting your help with ur formulas & code & your instructions.
Thank you for all of your help..
Sir I need translator formula so I can translate my work after finishing it in English to Arabic language..
Can you plz help me out with the formula or codes with your instructions plz you instructions help required..
I'm not well educated nor into technology just my passion for knowledge & learning.
Thank you
Regards
Mujeeb Ahmed.
2015-09-18 10:21 Reply Reply with quote Quote
Permalink 0 Sinourn
It's really helpful Thanks very much i was success with Kutools for Excel
2015-11-02 09:35 Reply Reply with quote Quote
Permalink 0 basil secusana
Thanks, i got it, it help me a lot
2015-11-09 13:02 Reply Reply with quote Quote
Permalink 0 Michelle
Hi! This is of great help but how about if i want to convert 1,234,567.89
to One Million Two Hundred Thirty Four Thousand Five Hundred Sixty Seven & 89/100 Only. Thank you.
2015-11-19 08:15 Reply Reply with quote Quote
Permalink 0 bhavana
is any short key for spell out Number Function
2015-11-28 05:57 Reply Reply with quote Quote
Permalink 0 Anil Sharma
Its is a very good formula, But I need the words in Indian format.
is any short key for spell out Number Function
2015-12-17 09:07 Reply Reply with quote Quote
Permalink 0 khalan
I have input 100,000 became One hundred thounthoun
what I need my currency 100,000 = One Sen
Please kindly help.
2016-01-08 14:29 Reply Reply with quote Quote
Permalink 0 Sonephet
I whant some help how to edit code vba excel What Want spell 1.200.000 = One million two hundred thousand only change in to My currency is One million two San only
2016-01-22 15:43 Reply Reply with quote Quote
Permalink 0 jayesh
Hi Sir,

I tried to save the macro as you mentioned above. and it is working fine. but if i close the excel and open a new sheet, it is not working . pls help

I also faced same issue, any help please. thanks
2016-01-23 20:12 Reply Reply with quote Quote
Permalink 0 jayesh
I tried to save the macro as you mentioned above. and it is working fine. but if i close the excel and open a new sheet, it is not working . pls help
2016-01-23 20:14 Reply Reply with quote Quote
Permalink 0 Pinky Sharma
Thanks..!
User can also try free GWORD Multi Currency Converter to Words.
Link - www.gwordformula.blogspot.com
2016-01-24 14:21 Reply Reply with quote Quote
Permalink 0 Gulraiz
Hi Sir,

I tried to save the macro as you mentioned above. and it is working fine. but if i close the excel and open a new sheet, it is not working . pls help
2016-02-03 09:13 Reply Reply with quote Quote
Permalink 0 Amit Roy
i done it sucessfully, thanks
2016-03-14 06:46 Reply Reply with quote Quote
Permalink 0 Imtiaz
Hi,

Tks for the formula. But I need it to show as US$ in front and after the cents the word only. How can I do that please:
2016-04-27 08:23 Reply Reply with quote Quote
Permalink 0 JohnE
Use concatenate...
For example, if you want to convert 5,362.86 to display US$ Five Thousand Three Hundred Sixty Two Dollars and 86 cents only", then use:
=CONCATENATE("US $ ",(spellnumber( A17))," only"). The result is US $ Five Thousand Three Hundred Sixty Two Dollars and Eighty Six Cents only
2016-06-23 21:40 Reply Reply with quote Quote
Permalink 0 Jaafar
TQ it works wonders!!
2016-07-01 09:43 Reply Reply with quote Quote
Permalink 0 Jaafar
it works wonders tq, happy happy happy
2016-07-01 09:44 Reply Reply with quote Quote
Permalink 0 Kaushik
How can i change the 244327565.75 - Twenty Four Crores Forty three lakhs Twenty Seven Thousand Five Hundred Sixty Five and Seventy Five Paise. Please show the step.
2016-07-22 10:57 Reply Reply with quote Quote
Permalink 0 Rohit Bansal
Thanks for the same.. it was indeed of great help!!
2016-07-23 06:23 Reply Reply with quote Quote
Permalink 0 shreenadh
FOR THIS PUPPIES 125420/-
THIS CODE GETTING ONE HUNDRED TWENTY FIVE THOUSAND FOUR HUNDRED TWENTY
I WANT ONE LAKH WENTY FIVE THOUSAND FOUR HUNDRED TWENTY
2016-07-27 11:27 Reply Reply with quote Quote
Permalink 0 raghu h n
spellnumber insert using visual basis but automatically is not working once i saved and open the document
2016-09-22 13:17 Reply Reply with quote Quote
Permalink 0 Saeed
Dear Admin, This is a very cool code which have programmed by you... Although, when I typed $200 the result shows (Two Hundred Dollars and no Cents)
and when I typed $0.2 the result shows (No Dollars and Twenty Cents).... The question is that when I didn't type any Cent in number (i.e $200) why result shows NO CENTS... Subsequently, when I didn't type any dollar in number (i.e $0.2) why result shows NO DOLLAR.... If I want to get result except aforesaid two question what should the code be?????
2016-10-19 05:24 Reply Reply with quote Quote
Permalink 0 adel
hi,
this is a great job ... thanks
but, how can change the dicimals to 3 digits instead of 2 digits.
appreciate it
adel
2016-10-19 10:26 Reply Reply with quote Quote
Permalink 0 adel
hi,
it is a great job, it worked very nice with me.
but, I need to change the dicimals from 2 to 3.
can you please assist me ?
kind regards
adel
2016-10-19 10:28 Reply Reply with quote Quote
Permalink 0 Chandra
I cannot save this features in excel. When i get out the file & reopen the file, it does not work. How can i save this? How can i get actuall figure without "no cents/ no dollars", if it's not needed. Please Email me in shown Mail ID.
2016-11-16 03:02 Reply Reply with quote Quote
Permalink 0 Khairul
Dear Sir, Its working fine for US dollar but i need for BD taka

Pls. help me
2016-12-26 12:49 Reply Reply with quote Quote
Permalink 0 Amanuel
Good evening,

I need exell to spell a mumber seperatelly for me. example:

a1 b1 c1 d1 e1
14,300.21 one four three zero zero basically in six coloums.
439.33 Four three nine
2017-01-17 21:20 Reply Reply with quote Quote
Permalink 0 paula
Hi,

Can you give the formula on how to convert the cents into fraction?
ex. $100.10 to one hundred dollars & 10/100 cents

Regards,
Paula
2017-02-15 12:04 Reply Reply with quote Quote
Permalink 0 Alpesh Patel
એક્ષેલ માં નંબર કે રકમને ગુજરતી શબ્દોમાં લખવા માટે

"Alpesh175" ગુગલમાં સર્ચ કરો.
2017-03-14 04:10 Reply Reply with quote Quote

Add comment


Security code
Refresh