I can probably modify mine to work for you. Here in the US we have dollars
and cents... you said rupees, which I presume corresponds to dollars... do
you have a sub-division of rupees that would correspond to cents?

Rick


"nandini" wrote in message
...
i want use this spell number function but as im in indian i need indian
currency for example 7812= seven thousand eight hundred twelve rupees
please
help me

"Daoud Fakhry" wrote:

Hi masters,
I would like to use spellnumber in my worksheet. I want that if I put
$200
using currency format in one cell it should give me Two Hundred US
Dollars
and No Cents and if I put AFA 200 using currency format it should be able
to
return Two Hundred AFA in another cell. I have found the following link
to
put in VBA code but some time this is also not working.
http://www.microsoft.com/office/comm...xp=&sloc=en-us

Is there any one who can help me, thanks.

Daoud Fakhry