excel numbers in to text

[johncena]

Dear friends i want to change numeric values into English words..for that i have tried this & it's work for me......
http://support.microsoft.com/kb/213360

I'm from oman.so here currency is not a dollars.here we are using Riyals...
Dollars = Riyals
Cents = Baisas

1 Riyal = 1000 Baisa

above VB code working only with two decimal places...but i need to change that to 3 decimal place..

if i want to change 120.525 above code changing as below..

120.525 - one hundred twenty riyals & fifty two baisas...

but it should be..
120.525 = one hundred twenty riyals & five hundred twenty five baisas..

pls help me to edit above code.thanks in advance...

[royUK]

See my example code here, you can specify currency in it

[johncena]

See my example code here, you can specify currency in it

sorry sir your code has 3 parts(pound,pence & cents).but i have only two (Reyals & Baisas)..
how i have to use this code..pls tell me i didn't understand anything.....

[Marcol]

Heres one I made earlier

In the demo workbook Select Currency from Drop-Down in A2

This will convert all to words

Please Login or Register  to view this content.

This will convert the principal unit to words and the minor unts as a number

Please Login or Register  to view this content.

Change "&" to change the separators e.g. "-" or "and" etc, if ommitted the default is "and"

The default is

Please Login or Register  to view this content.

This will convert the principal unit to words and the minor unts as a number and use "and" as a separator.

Hope this helps

[johncena]

Heres one I made earlier

In the demo workbook Select Currency from Drop-Down in A2

This will convert all to words

Please Login or Register  to view this content.

This will convert the principal unit to words and the minor unts as a number

Please Login or Register  to view this content.

Change "&" to change the separators e.g. "-" or "and" etc, if ommitted the default is "and"

The default is

Please Login or Register  to view this content.

This will convert the principal unit to words and the minor unts as a number and use "and" as a separator.

Hope this helps

where i have to put values..

[Marcol]

The values are in column A in the demo workbook.

Put your values in column A in this workbook.

[johncena]

The values are in column A in the demo workbook.

Put your values in column A in this workbook.

thanks .but I'm facing to same problem.. R 120.525 your formula making like this..

Please Login or Register  to view this content.

but i need like this..

Please Login or Register  to view this content.

[Marcol]

Okay I see your problem now, give me an hour or so.

[johncena]

Okay I see your problem now, give me an hour or so.

no problem friend take your time.thanks a lot for your all efforts....

[Marcol]

Okay try this, check the Baisas, I'm not sure how you write them in numbers and read them back.

Put your values in column A in this workbook
Change the arguements with the drop-downs in A2 & B2

This will convert all to words

Please Login or Register  to view this content.

This will convert the Riyals to words and leave the Baisas as a number

Please Login or Register  to view this content.

Change "&" to change the separators e.g. "-" or "and" etc, if ommitted the default is "and"

The default is

Please Login or Register  to view this content.

This will convert the Riyals to words and leave the Baisas as a number and use "and" as a separator.

Hope this helps

[johncena]

Okay try this, check the Baisas, I'm not sure how you write them in numbers and read them back.

Put your values in column A in this workbook
Change the arguements with the drop-downs in A2 & B2

This will convert all to words

Please Login or Register  to view this content.

This will convert the Riyals to words and leave the Baisas as a number

Please Login or Register  to view this content.

Change "&" to change the separators e.g. "-" or "and" etc, if ommitted the default is "and"

The default is

Please Login or Register  to view this content.

This will convert the Riyals to words and leave the Baisas as a number and use "and" as a separator.

Hope this helps

ohh thanks a lot friend.now it's work very well..thanks a million...

[Marcol]

Happy to have helped

TIP
Don't quote whole posts in your replies, the moderators don't like it.....

Only quote posts if they are relevant to some query, and then only quote the relevant part of the post.

[warrierscorpion_2002]

Hi friends

I am from India. I wish to know if a numerical value, Rs.123456.78/-, i want this number to be converted into words / text to read as Indian Rupees One hundred Twenty Three Thousand Four Hundred Fifty Six and Paise Seventy Eight.

Kindly help

thanks in advance
shankaran

[Domski]

Hi,

Please take a moment to familiarise yourself with the forum rules.

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Dom

[moijul]

Hi,
Greetings,

I'm from oman. Here we are using Riyals...


1 Riyal = 1000 Baisa

I want to know how to convert numeric of Omani Riyal Into word in excel..

Example;-
120.525 = one hundred twenty riyals & five hundred twenty five baisas..

pls help me...

[FDibbins]

moijul welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.