spellnumber

  1. M

    SPELL NUMBER VBA

    Anyone knows how to remove the repeated "only" ? Thanks. Function readmoney_Mei(ByVal pNumber) Dim Ringgit, Cents arr = Array("", "", " Thousand ", " Million ", " Billion ", " Trillion ") pNumber = Trim(Str(pNumber)) xDecimal = InStr(pNumber, ".") If xDecimal > 0 Then Cents =...
  2. B

    Spell number in excel

    How can I spell a number like 1-100 in excel: 57 = Fifty Seven?
  3. M

    SpellNumber

    Hi Mr. Excel. How can i use SpellNumber without Dollar. example i write 1600000-One Million, Six Hundred Thousand,Only
    • mutuku
    • Thread
    • 1600000-one million spellnumber thousand write
    • Replies: 4
    • Forum: Excel Questions
  4. V

    SpellNumber in my native language (Bulgarian)

    Hi, I've been looking accross the internet for a formula to spellout my numbers in excel and I came by the SpellNumber. So I edited it in my native language (Bulgarian) but the problem is that here we don't spell "one hundred" "two hundred" etc. but we have a single word for 100, 200, 300 etc...
  5. G

    spellnumbers in Indonesian Currency

    Hi Guys, I'm currently editing the spellnumber function that I got from support.microsoft.com so that it can accommodate Indonesian currency. I've searched the forum and turned up with results that contain Rupees (Indian currency), pretty close, but not there. Indonesian currency is pretty...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top