Spellnumber

**Williams** · 09-25-2006, 04:03 AM

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.

**Special-K** · 09-25-2006, 06:05 AM

To convert from dollars to dinar divide by 3.44

**Williams** · 09-25-2006, 08:03 AM

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

**oldchippy** · 09-25-2006, 08:50 AM

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

**Williams** · 09-25-2006, 12:26 PM

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.

**oldchippy** · 09-25-2006, 02:46 PM

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:

**Williams** · 09-25-2006, 03:05 PM

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.

**Williams** · 09-25-2006, 03:17 PM

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

**oldchippy** · 09-26-2006, 09:26 AM

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

**kaleeckal** · 09-21-2010, 01:48 PM

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.

**athwal2k** · 08-08-2012, 04:51 AM

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

**arlu1201** · 08-08-2012, 04:56 AM

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.

**gelaisimple0001** · 02-16-2020, 02:36 AM

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.

**AliGW** · 02-16-2020, 03:34 AM

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