+ Reply to Thread
Results 1 to 14 of 14

Spellnumber

  1. #1
    Registered User
    Join Date
    09-15-2006
    Posts
    7

    Talking Spellnumber

    Dear All,

    Can anyone help me to have the spellnumber value in KD (Kuwait Dinar)? When I do the formula I am getting the value in USD.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,041
    To convert from dollars to dinar divide by 3.44
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    09-15-2006
    Posts
    7

    Talking

    I am getting a value like this :Four Hundred Eighty Dollars and Seventy One Cents. Instead of Dollars I want to have it in KD. Pls help me

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Thumbs up

    Quote Originally Posted by Williams
    I am getting a value like this :Four Hundred Eighty Dollars and Seventy One Cents. Instead of Dollars I want to have it in KD. Pls help me
    Hi,

    Here's a link to the code you need, just edit it to the currency you want

    http://support.microsoft.com/default...;EN-US;Q213360

    oldchippy

  5. #5
    Registered User
    Join Date
    09-15-2006
    Posts
    7

    Talking

    I did that too. When I first used the formula 'spellnumber' it was not at all working. Afterwards I had a google search and got the codes that I have to paste it in the module sheet. Afterwards I started getting the value in Dollars and Cents. I have seen others using this as Dhs (UAE). I am trying to get the codes to use it in KD and Fils.

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Quote Originally Posted by Williams
    I did that too. When I first used the formula 'spellnumber' it was not at all working. Afterwards I had a google search and got the codes that I have to paste it in the module sheet. Afterwards I started getting the value in Dollars and Cents. I have seen others using this as Dhs (UAE). I am trying to get the codes to use it in KD and Fils.
    Hi Williams,

    Try this, I've replaced dollars and cents with Kuwait Dinars and fils, is this OK?


    HTML Code: 

  7. #7
    Registered User
    Join Date
    09-15-2006
    Posts
    7

    Talking

    Thank you very much, it is working perfectly. I have two more questions.

    (1) In case of no fils rather than having it as 'no fils' can I have 'only'. For example when I tried to do with 25 it comes as 'Twenty Five Kuwait Dinar and No fils'. If there is no fils can I have just Twenty Five Kuwait Dinar only.

    (2) Whenever I wanted to use this formula do I have to go to the module and insert the code. Is there anything that I can do to make this formula work in all my worksheet?

    Thank you very much for the help. I never expected to get a very good response.

  8. #8
    Registered User
    Join Date
    09-15-2006
    Posts
    7

    Talking

    Dear, this is to update you that the formula is not working perfectly. See the response that I am getting:->

    for KD 122.050 I got: One Hundred Twenty Two Kuwait Dinar and Five fils

    the correct answer has to be: One Hundred Twenty Two Kuwait Dinar and Fifty fils

  9. #9
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Thumbs up

    Hi Williams,

    Thanks for your reply. I know your question isn't that difficult unfortunately I have very limited knowledge of VBA and unable to give you the macro you require. But hopefully someone with more knowledge on how to edit the macro to give three decimal places and the correct answer in words will pick this up. If you don't get a reply try re-posting in a day or so.

    All the best

    oldchippy

  10. #10
    Registered User
    Join Date
    09-21-2010
    Location
    Kuwait
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Spellnumber

    Hi All

    1. Start Microsoft Excel.
    2. Press ALT+F11 to start the Visual Basic Editor.
    3. On the Insert menu, click Module.
    4. Copy & Paste the following code into the module sheet.
    5. Go to Excel Sheet and put any Kuwaiti Dinar value with 3 decimals in cell A1
    6. Type [I]=SpellNumber(A1)[/I] in cell B1
    Hope it will solve your Problem


    Please Login or Register  to view this content.
    Last edited by kaleeckal; 09-22-2010 at 02:55 PM.

  11. #11
    Registered User
    Join Date
    08-08-2012
    Location
    Kuwait
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Spellnumber

    but the result it is giving is in "Dinars" not in "Kuwaiti Dinars"

  12. #12
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Spellnumber

    athwal2k,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  13. #13
    Registered User
    Join Date
    02-16-2020
    Location
    Bahrain
    MS-Off Ver
    2007
    Posts
    1

    Re: Spellnumber

    Hi everyone,

    I need to convert Bahraini Dinars into words in Excel. I followed the steps in copying and pasting the formula in Module but still not working.
    Btw, my excel version is 2007, could that be the reason why?

    Thanks in advance.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,616

    Re: Spellnumber

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1