View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
 
Posts: 216
Default SpellNumber Function

KK<

Can you give some number examples and how you want to see the result?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"capisco" wrote in
message ...

http://support.microsoft.com/?kbid=213360
This is the basic spellnumb
er macro form microsoft
it spells number in english
so i want ot convert it to convert numbers to arabic the main problems
a
in arabic we say like one thousand as one word
and two thousand as one word too so i need to make a function that
will cal
l from 1000 to 9000
and same for hundred we say one hundred as one word and two hundred as
one w
ord
so i need another function for hundred
the other problem is that we write numbers from right to left
like :
78
we spell it like eighty seven
so i need to make the 78.76
spelled like eighty seven and sixty seven cents
also we say eighty and seven and sixty and seven cents
so i need and after each one
so could any one help me in that
i would be greatful
Thanks
KK


--
capisco
------------------------------------------------------------------------
capisco's Profile:

http://www.excelforum.com/member.php...o&userid=19569
View this thread: http://www.excelforum.com/showthread...hreadid=543629